Thread: Trim a cell that has names and address to only show name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christie Christie is offline
external usenet poster
  
Posts: 25
Default Trim a cell that has names and address to only show name
I have quite a few cells that have alot of information in them eg surname,
christian name and address. I only need the surname and christian name in one
cell. How can I do this?
eg Smith Jones 123 Harper St Manly (A1). I need the cell to only show Smith
Jones (B1)
Reply With QuoteReply With Quote