reverse of concatenate function

[halcyoneus]

I have a column in a spreadsheet that I need to slip up the info in 1 cell into 2 seperate cells. For example...the cell has the following info in it.

P355522\2352071

I need the 2 sets of numbers in seperate cells.

Note, all the numbers are different in each cell of the above mentioned column, but the format and # of characters are all the same (ie the letter P with 6 #'s, followed by a "\" and 7 #'s).

~Hal

 

[Von Pookie]

Use Text to Columns (from the data menu). Just set the delimiter to the \ symbol.

 

[halcyoneus]

Awsome,
worked perfect.

Thanks
~Hal