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