Data Position
Closed
arun
-
2 Jun 2009 à 06:02
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 3 Jun 2009 à 00:22
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 3 Jun 2009 à 00:22
Related:
- Data Position
- Potplayer remember playback position - Guide
- Tmobile data check - Guide
- Mint mobile data not working ✓ - Network Forum
- How to copy data from one excel sheet to another - Guide
- Data transmission cables - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday 12 April 2009
Status
Member
Last seen
16 February 2010
166
3 Jun 2009 à 00:22
3 Jun 2009 à 00:22
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 ....
