separating text from cells
If all names had a middle initial would that solve your problem? If so can
you use a number or character when there is no middle initial. A null
character or blank could work??
"kikilein" wrote:
I have a column of names first name, middle initial (sometimes), last name.
I have a hard time to separate that middle initial that some of the names
have but not all. I tried the Data text to column but have a hard time
seperating the middle intitial. Any ideas on how to do it?
Thanks much.
|