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.

Based on the values in cells b77 b81
Based on the values in cells b77 - Best answers
Cells b77 b81 - Best answers
Help me to add particular cells ✓ - Forum - Excel
Based on the values in cells b77 b81 what function can automatically return the value in cell 77 ✓ - Forum - Excel
Based on the values in cells b77 b81 which function can automatically return the value in cell 77 ✓ - Forum - Excel
Conversion of values already present in cells ✓ - Forum - Excel
Find values based on colum and sum in a table - Forum - Office Software

1 reply

Answer 1 / 1

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

Subscribe To Our Newsletter!