Related:
- Separating items from columns
- Using notepad++ to separate text to columns ✓ - Forum - Excel
- Search for matches from columns on separate sheets. ✓ - Forum - Excel
- A separate or external file with extension is created to store css declaration - Articles
- Shortcut key to delete an item permanently is - How-To - Keyboard
- Cmyk separation plugin for gimp - How-To - The Gimp
1 reply
TrowaD
- Posts
- 2693
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 18, 2021
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
Subscribe To Our Newsletter!
- Posts
-
2693
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 18, 2021
455It'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