View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dawn
 
Posts: n/a
Default Removing data from cell within an excel spreadsheet

I have a very large spreadsheet in which column A contains a list of names
e.g. Fred Bloggs. I need only the surname in this column - is there anyway I
can remove the christian name without having to do this individually cell by
cell.