reverse of concatenate function

halcyoneus

Board Regular
Joined
Mar 26, 2003
Messages
147
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

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Use Text to Columns (from the data menu). Just set the delimiter to the \ symbol.
 

Forum statistics

Threads
1,078,373
Messages
5,339,816
Members
399,334
Latest member
Grace Ford

Some videos you may like

This Week's Hot Topics

Top