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
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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
0
Thanks so much! Would this work if the v-xxxx is the first or the last letters in the cell?
0
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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
0
Thanks Trowa!
0