Text to Colums

  • Thread starter Thread starter blander
  • Start date Start date
B

blander

Hi guys,

I have 23 k records

The colum are names like Mr John Smith, Brad Brown and Mrs Sarah Jones

When i use text to colums it obviously puts

Colum A
Mr
Brad
Mrs
Colum B

John
Brown
Sarah

Colum C

Smith
Jones

The Mr and Mrs are in the same colum as Brad which would be incorrect
as the Mr and Mrs are salutations and Brad is a first name

Anyway of putting them in the correct colums??

Thanks!!
 
So i've just thought of finding all the Mr, Mrs etc and getting rid o
them as a last resort.. (even though i would like to keep them) excep
when you do a find and replace, it replaces them with a space... s
when you do the text to colums it puts the space in its own colum.. s
the names are all over the place..
 
Back
Top