e.g. 'HL' with H being for High and L being for L
What I really wanted was two columns with the first column having all the first digit values and the second column all the 2nd digit values
Column 1 'H'
Column 2 'L'
Is there any easy command to do this in one go rather than have to manually change everything?
Say your data is in column A, starting at A1
In B1 type
In C1 type
Copy these formulae down columns B & C.
Copy all columns B & C and paste special values to get 2 columns showing the first then second digits
Yes. Use the Data | Text to Columns... menu command.
But first, insert a new column to the left of your
data. Next select the column containing your data,
and choose the Data | Text to Columns... menu
command. Click the "Fixed width" radio button
at Step 1 of 3, and then press [ Next> ]. At
Step 2 of 3, click in the "Data preview" field
creating a vertical line between "H" and "L", and
then press [ Finish ].