ExcelBanter - Splitting Rows

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Splitting Rows (https://www.excelbanter.com/new-users-excel/76612-splitting-rows.html)

ALoecher

Splitting Rows

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.

Ron de Bruin

Splitting Rows

Hi v

You can use dataText to columns first and then use
CopyPastespecial Tranpose to paste in rows

--
Regards Ron de Bruin
http://www.rondebruin.nl

"ALoecher" wrote in message ...
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.

All times are GMT +1. The time now is 03:43 AM.