How to move data in excell?
Closed
Woody
-
Nov 6, 2011 at 08:47 PM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Nov 8, 2011 at 12:54 PM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Nov 8, 2011 at 12:54 PM
Related:
- How to move data in excell?
- Tmobile data check - Guide
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- Data transmission cable - Guide
- Gta 5 data download for pc - Download - Action and adventure
1 response
aquarelle
Posts
7181
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2025
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
