On Jul 10, 8:10 pm, "Hilton" wrote:
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 ...