Splitting Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an interesting problem. I have a worksheet where I have several items
seperated by semicolons in a cell. I want to split them but place the split
items in the rows below, not the columns. Any help is appreciated.
 
Hi v

You can use data>Text to columns first and then use
Copy>Pastespecial Tranpose to paste in rows
 
Back
Top