How to seperate values in the same colomn

Closed
Toa - Mar 17, 2010 at 05:37 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 17, 2010 at 09:18 AM
Hello
Can some 1 help me please im trying to set up a spread sheet, i have different information in one column, i just want to seprate it for e.g
A1
M1234
M1235
M1236
M1237
U1000
U1001
U1002
U1003
M1238
M1239
M1240

These are all in the same column i want to be able to seperate them and send to another spread sheet to calculate how many have been made.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 17, 2010 at 09:18 AM
separate how?
Have you looked into Text to column functionality that is found under "Data" tab
0