Separating items from columns
Solved/Closed
DG83
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
Sep 17, 2012 at 08:31 AM
DG83 - Sep 18, 2012 at 10:36 AM
DG83 - Sep 18, 2012 at 10:36 AM
Related:
- Separating items from columns
- All items in little alchemy - Guide
- Acnh halloween items 2023 - Guide
- Excel data validation list from table multiple columns - Guide
- Mac disable recent items - Guide
- Clear recent items windows 11 - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Sep 17, 2012 at 11:04 AM
Sep 17, 2012 at 11:04 AM
Hi DG83,
See if this formula can help you:
=MID(A1,SEARCH("v-",A1),6)
Assuming the following:
1. "v-" is not used elsewhere in cell
2. the extracted data is always 6 figures long
Best regards,
Trowa
See if this formula can help you:
=MID(A1,SEARCH("v-",A1),6)
Assuming the following:
1. "v-" is not used elsewhere in cell
2. the extracted data is always 6 figures long
Best regards,
Trowa
Sep 17, 2012 at 11:40 AM
Sep 18, 2012 at 10:25 AM
It's up to you to see if this formula works for you.
But to answer your question, the folowing:
A v-3652
A v-3652 A
v-3652 A
Av-3652
Av-3652A
v-3652A
v-3652
Will all result in: v-3652
Best regards,
Trowa
Sep 18, 2012 at 10:36 AM