Changing paste order

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi,

If I copy Haig Paul into a single cell but want it to read Paul Haig in the
cell or 2 cells what do I have to do?

It has a comma

VMT

Paul
 
Hi Paul,

You can use following formula, if you have this data in cell A1:-
=MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1))&" "& MID(A1,1,FIND(",",A1)-1)

Thanks & Regards,
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
You must log in or register to reply here.

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

Copying conditional formating 5
Outlook Reminders on Windows 7? 5
Zero Values 2
Splitting data in a single cell that is seperated by commas, then moving to make individual rows 2
Count Numeric Value with condition 5
Bulleted or numbered list inside cell? 1
How do I copy data in single cell format to a merged cell format 1
Split Cell Range into Multiple Cells 1

Back
Top