View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zack Zack is offline
external usenet poster
 
Posts: 17
Default Spilting a column

I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way to
create a method to use the comma in between the "smith, bob" to separate the
data into 2 columns?