How to split up text

[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

 

[Mark K]

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

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

 

[Dennis]

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

 

[Mike H]

Select your column then

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


Mike

 

[Stefi]

Data>Text to columns, set / as separator

Regards,
Stefi

„Hilton†ezt írta:

 

[Ron Rosenfeld]

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

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