Thread: Siple but what was the formula for splitting names?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Martyn Martyn is offline
external usenet poster
  
Posts: 18
Default Siple but what was the formula for splitting names?
Hi,
I need the formula for splitting names...
i.e need "Martyn Williams" in A1 to be splitted to "Martyn" and "Williams"
in B1 and C1
TIA


Reply With QuoteReply With Quote