H Hilton Jul 10, 2008 #1 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
M Mark K Jul 10, 2008 #2 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 ...
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 ...
D Dennis Jul 10, 2008 #3 Highlight your cells and then select from the menu Data - Text to Columns and follow the steps through the wizard
Highlight your cells and then select from the menu Data - Text to Columns and follow the steps through the wizard
M Mike H Jul 10, 2008 #4 Select your column then Data|Text To Columns Select 'Delimited' Next Put a / in the other box Finish Mike
Select your column then Data|Text To Columns Select 'Delimited' Next Put a / in the other box Finish Mike
S Stefi Jul 10, 2008 #5 Data>Text to columns, set / as separator Regards, Stefi „Hilton†ezt Ãrta:
R Ron Rosenfeld Jul 10, 2008 #6 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
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
