ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I reverse information in a cell example last name, first n (https://www.excelbanter.com/excel-programming/376490-how-do-i-reverse-information-cell-example-last-name-first-n.html)

elrusty

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

kassie

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


rajivpopat

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