![]() |
How do I reverse information in a cell example last name, first n
Need to reverse information in a cell example last name, first name
|
How do I reverse information in a cell example last name, first n
Say you have your name and surname in A2, then in B2 enter this formula
=MID(A2,FIND(" ",A2)+1,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1) "elrusty" wrote: Need to reverse information in a cell example last name, first name |
How do I reverse information in a cell example last name, first n
are you trying to reverse characters of word - e.g -
Joe becomes oeJ Or Joe Smith becomes Smith Joe "elrusty" wrote: Need to reverse information in a cell example last name, first name |
All times are GMT +1. The time now is 01:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com