Split data after each semicolon

[yarlagadda]

Hello Everyone,

I have some data in a cell with around 500 numbers each separated by a semicolon as shown below:-

P00039936;P00033582;P00001315;P00023755;P00002315;

Now I want to separate each number after the semicolon and put it in different rows in a column. Is this possible? If possible, how?

Regards,
Yarlagadda.

 

[rpaulson]

Data menu then text to columns

 

[yarlagadda]

But it adds all the values in the same row in different columns isn't. I want it the other way round (the values in different rows of the same column).

Regards,
Yarlagadda.

 

[rassten]

Another way:

Excel Workbook
	A	B	C	D	E	F
1	P00039936;P00033582;P00001315;P00023755;P00002315;
2	P00039936
3	P00033582
4	P00001315
5	P00023755
6	P00002315
7
Ark4

 

[yarlagadda]

Got it. Just did text to columns and then transpose!!!!!!!
MrExcel.com Rocks!!!!!!!!!

Regards,
Yarlagadda.