Data Position

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I want to change the position of content into a cell in Excel. For example, I want to get this "Ha 100'' data back as ''100 Ha''. into another cell using fornula. Is there anything like this ? If yes, then please help.

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
It depends what type of data you have .... if you have same format as one space between two words then use this formula suppose you data

A1=HA 100

Now put below formula in Cell B1 as

B1=RIGHT(A1,(LEN(A1)-FIND(" ",A1,1)))&" "&LEFT(A1,(LEN(A1)-FIND(" ",A1,1))-1)

Result = 100 ha


PS. it will convert position of two words if they have a space " " between them ......

Feel free in case of any confusion ....