Splitting data

  • Thread starter Thread starter SDW
  • Start date Start date
S

SDW

Hi
If I have a col. of cells with personal names such as: Mr John Smith : can
I split this into Mr John Smith all in seperate cols.?
Thanks in advance
Stephen West
 
Hi

You can do so by using the following reference in the
destination cell =rigt(A1,5)

Regards
N. Narayana Swamy
 
Back
Top