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

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?

Separating items from columns
Outlook duplicate items remover (odir) - Download - Email
Tweetdeck larger columns - Guide
All 580 little alchemy items - Guide
Display two columns in data validation list but return only one - Guide
How to delete columns in word - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

DG83
Sep 17, 2012 at 11:40 AM

Thanks so much! Would this work if the v-xxxx is the first or the last letters in the cell?

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 18, 2012 at 10:25 AM

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

DG83
Sep 18, 2012 at 10:36 AM

Thanks Trowa!

Similar discussions

Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes

Similar discussions

Subscribe To Our Newsletter!