Transferring data from one worksheet to anoth
Closed
YBB
-
Apr 26, 2012 at 06:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 26, 2012 at 09:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 26, 2012 at 09:45 AM
Related:
- Transferring data from one worksheet to anoth
- Transfer data from one excel worksheet to another automatically - Guide
- Free fire id transfer facebook to google - Guide
- Tmobile data check - Guide
- How do you add a username or author to a worksheet - Guide
- How to be offline in whatsapp when data is on - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 26, 2012 at 09:45 AM
Apr 26, 2012 at 09:45 AM
Hi YBB,
It's always usefull to provide sample data to find a solution.
If your data is consistent and looks something like this:
A1: ABC123
You could use:
=LEFT(A1,3) to get the text.
=RIGHT(A1,3) to get the numbers.
Obviously this method will only work when the size of the text and numbers remains the same.
If there is a space between the text and number then you could use the text delimiter option.
Please provide some sample data if the above doesn't solve your query.
Best regards,
Trowa
It's always usefull to provide sample data to find a solution.
If your data is consistent and looks something like this:
A1: ABC123
You could use:
=LEFT(A1,3) to get the text.
=RIGHT(A1,3) to get the numbers.
Obviously this method will only work when the size of the text and numbers remains the same.
If there is a space between the text and number then you could use the text delimiter option.
Please provide some sample data if the above doesn't solve your query.
Best regards,
Trowa