Copying first digit only of a two-digit field
Posted by Roger on July 31, 2001 6:48 AM
Due to some bad design by a colleague I'm lumbered with one long column of data with each cell having two digits(?) of text in it
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?