Separating items from columns [Solved/Closed]

Report
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
 DG83 -
Hello guys,

Could you please help with this... Is it possible to do the following in excel:
I have similar cells to this in one column: Ford v-3652 burst (this is in one cell).
I would only like to display in a new cell the v-3652 number and not the rest.
This v-xxxx number is not always the second in a cell, can be the first or the last as well.
Any ideas how to separate them out?

1 reply

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
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
Thanks so much! Would this work if the v-xxxx is the first or the last letters in the cell?
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
Hi DG83,

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
Thanks Trowa!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!