How to split up text

  • Thread starter Thread starter Hilton
  • Start date Start date
H

Hilton

How to change
LSD/1/1
REMAD/1/2
NSFE/1/1
CLKSAD/2/1

into
LSD 1 1
REMAD 1 2
NSFE 1 1
CLKSAD 2 1

Thanks
 
How to change
LSD/1/1
REMAD/1/2
NSFE/1/1
CLKSAD/2/1

into
LSD 1 1
REMAD 1 2
NSFE 1 1
CLKSAD 2 1

Thanks
Click to expand...
How to change
LSD/1/1
REMAD/1/2
NSFE/1/1
CLKSAD/2/1
Click to expand...

Use Convert Text to Columns - Either Ex 03 Tools/Text to Columns or Ex
07 Data/Text to Columns

Select the column with the data in it.

Select delimited and click Other and put / in the box provided

Click ok and presto it will separate your data into separate columns.

Cheers ...
 
Highlight your cells and then select from the menu Data - Text to Columns and
follow the steps through the wizard
 
Select your column then

Data|Text To Columns
Select 'Delimited'
Next
Put a / in the other box
Finish


Mike
 
How to change
LSD/1/1
REMAD/1/2
NSFE/1/1
CLKSAD/2/1

into
LSD 1 1
REMAD 1 2
NSFE 1 1
CLKSAD 2 1

Thanks
Click to expand...

If what you mean is to split your strings into columns, then:

Use the Data/Text to Columns wizard (from the Data menu) and select Delimited;
then "/" as the delimiter.

If what you mean is to replace the "/" with multiple spaces, then use a formula
similar to:

=substitute(A1,"/"," ")

--ron
 
Back
Top