Thread: Help!! Formulas
View Single Post
  #1   Report Post  
Simon
 
Posts: n/a
Default Help!! Formulas

Can anyone help??

I have a name in cell A1, but I want to split the name into cells A2 and A3.
eg, A1 = Simon Thomas, I want B1 to = Simon & C1 to = Thomas
Does anyone know the formula for this??

Thank you in advance