macro for spliting semi colons to diffrent rows

[yantan2006]

Good Day,

I have an csv file opened in ms excel 2007, all the data is in one column A, and all the pieces of information (data) is spereated with semi colon in a single column A.

I need a macro that would seprate each piece of infromation sepreated with semi colon to another column B and c and so on. Depending on semi colons in column A.

Thanks a lot

 

[Marcelo Branco]

Hi,

Try
Data > Text to Columns
Delimited
pick semicolon

M.

 

[yantan2006]

superb, Thanks a Lot Genius

 

[Marcelo Branco]

Tks for your kind words and for the feedback

M.