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!!
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!!