View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
buggles buggles is offline
external usenet poster
 
Posts: 4
Default splitting Last Name, First Name

I have a field with Last name separated by a comma and then First Name (ie
Smith, John). The names are not the same length and comma is not at same
place (if so, text to colum would work).

Is there a way to split field to get last name in one colum and first name
in another colum?
thanks
Sal