On Thu, 10 Jul 2008 12:10:21 +0200, "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

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