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.
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
--
Regards Ron de Bruin
http://www.rondebruin.nl
"ALoecher" <[email protected]> wrote in message news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks