How to move data in excell?
Closed
Woody
-
Nov 6, 2011 at 08:47 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Nov 8, 2011 at 12:54 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Nov 8, 2011 at 12:54 PM
Related:
- How to move data in excell?
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How to take screenshot in excel - Guide
- How to be offline in whatsapp when data is on - Guide
- Number to words in excel - Guide
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Nov 8, 2011 at 12:54 PM
Nov 8, 2011 at 12:54 PM
Hi,
I supposed that your cell containing "241 GOLD CREEK RD, BROOKFIELD, QLD 4069" is A2. Use the following formula for B2 and C2.
B2=LEFT(A2, FIND(",",A2,1)-1)
C2=RIGHT(A2,LEN(A2)-FIND(",",A2,1)-1)
Best regards
I supposed that your cell containing "241 GOLD CREEK RD, BROOKFIELD, QLD 4069" is A2. Use the following formula for B2 and C2.
B2=LEFT(A2, FIND(",",A2,1)-1)
C2=RIGHT(A2,LEN(A2)-FIND(",",A2,1)-1)
Best regards
