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
- How to automatically transfer data between sheets in Excel - Guide
- Tmobile data check - Guide
- Display two columns in data validation list but return only one - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
