Splitting data

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
 
N

Narayan

Hi

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

Regards
N. Narayana Swamy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
Auto Fill Word Documents 4
Parsing full name into salutation, First, middle, last, Suffix 1
parsing a full name out into Last, First, Middle 2
Formula for names 6
change full name to: title + initial(s) + surname 13
Removing multiple duplicate events 11
Mail Merge - List multiple items then page break on unique data 1

Top