Thread: Parse text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 390
Default Parse text

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