String function

  • Thread starter Thread starter Matti
  • Start date Start date
M

Matti

What is the easiest way to pick up a string of characters
and save them to another column until the ,is found. For
example I would like to seperate the information
02,0908
0348,03
05,0424

to two columns.

Thank you
 
Select the column, use Data/Text to Columns, select Delimited in first screen, click the 'comma' check box in 2nd, then click finish
 
Format the receiving cells as text beforehand if you
want leading zeros.
Select the cells or column to be split up.
Data, Text to Columns, Delimited, comma for delimiter

Try on a copy of your worksheet.
 
Back
Top