how do you flip the order of the content in a cell.

M

MLD

How do I flip the order of the content in a cell. i.e if the cell reads
Michael Smith how do I get it to flip to Smith Michael without having to
retype.
 
R

Rick Rothstein \(MVP - VB\)

This formula will flip the two as you have shown...

=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))

However, if you want to flip them and put a comma separator in the flipped
text, use this formula...

=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)

Rick
 

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

Print order of TriFold - Publisher 365 0
Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Office JS api to handle redo/undo , delete event for content control class 0
how to flip contents inside the cell of an excel? 2
Top Fold Booklet 1
Delete all data after a symbol in a field 0
Auto Fill Word Documents 4
Active Content in this file is blocked issue 1

Top