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
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