Transferring data from one worksheet to anoth
Closed
YBB
-
26 Apr 2012 à 06:59
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Apr 2012 à 09:45
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Apr 2012 à 09:45
Related:
- Transferring data from one worksheet to anoth
- Transfer data from one excel worksheet to another automatically - Guide
- How to copy data from one excel sheet to another - Guide
- App for transferring money internationally - Guide
- How to export data from facebook - Guide
- Transfer data from excel to excel ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
26 Apr 2012 à 09:45
26 Apr 2012 à 09:45
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
