Data Position

Closed
arun - Jun 2, 2009 at 06:02 AM
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
- Jun 3, 2009 at 12:22 AM
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

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
Jun 3, 2009 at 12:22 AM
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 ....
0