Hi Max
Ensure that you have two empty columns to the right of your data column.
Select the ColumnDataText to ColumnsDelimitedcheck SpaceFinish.
The data you want will now be in the second column.

--
Regards
Roger Govier

"Max" wrote in message
...
Hello All,

I have a column that is not consistent in the way data stored:

75 F1 Automatic
100 M1 Manual
94.02 C1 As requested

Note every column start with a number.

All I need is the F1, M1, C1 in the next column.

Thanks