I have a list of salutations, as attached.
I want to flip the order of the cells, e.g. Diedre and Aaron in b2 to become Aaron and Diedre in d2. I made an attempt which is not working, see d2.
The reason I am doing this is so that I can compare C2 and D2. If they are the same, it means both the primary salutation and spouse primary salutation cells are formatted correctly, and I can eliminate them from checking. (the actual list is 3600 rows long).
Try this one
in C2 and copy down
Formula:
Please Login or Register to view this content.
or this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try this in D2 and copy down:
Formula:Please Login or Register to view this content.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Another way.Formula:Please Login or Register to view this content.
Dave
Thank you, AlKey. It seems to be diong the trick very nicely. Can y ou explain to me what is going on, as I am not familiar with "substitute". Thank you.
The second formula that I suggested uses TRIM function, RIGHT function and SUBSTITUTE.
=TRIM(RIGHT(SUBSTITUTE(B2," ",REPT(" ",99)),99))&" and "&A2
substitute looks for the last space from the right to get the last word and replaces the rest of the string with bunch of spaces. Then I add &" and "&A2
Thanks, I get the basic drift.
Thank you, FlameRetired.
You are welcome. Thank you for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks