Extracting data from a cell and inserting into an adjacent cell

[JohnnyBoyxxx]

Hi,
I'm looking to see if it's possible to extract the product codes from a cell and insert them in an adjacent cell.

In the sample provided you'll see product descriptions in Col C for a variety of products that we use.

HP always use **-****** 2 letters, a dash followed by a 6 or 7 mixture of numericals and letters
MSI use 4-5 digits, a dash followed by 3 more etc.

If it is possible i'd like to extract these codes into the adjacent cell in Col B

Many thx in advance guys

John

[walruseggman]

In your example sheet, can you show the output you want in column B for a handful of the codes in column A? It's not really clear to me what you're wanting

[JohnnyBoyxxx]

Hi, Thx for your response,

I've updated the sample to reflect your request. NOTE; The codes need to be extracted from Column C

[walruseggman]

Are Toshiba, Dell, HP, MSI, Asus, and Lenovo the only manufacturers you'll encounter? Are the products codes always the same format for each of them? If not, will they always bee in the same place in the string for each manufacturer? If not, I'd imagine there's too much intelligence involved to write a VBA script that could capture 100% of the codes.

[JohnnyBoyxxx]

I would say that 95% of our product range is between HP, Asus and MSI and they are pretty consistence with there codes.The rest i'm not too bothered about. If there was anything that would help erase the manual aspect of copy and pasting that i'm doing now, it would be a huge help.

Regards
John

[sintek]

Hi JohnnyBoyxxx

You can give this a try

Please Login or Register  to view this content.

[jindon]

JohnnyBoyxxx

This extracts correct result based on data uploaded.
Upload more different data if this does not extract correct string for actual data.

Please Login or Register  to view this content.

[JohnnyBoyxxx]

Hi, This forum is amazing, many thanks to sintek and jindon for your replies and efforts in answering my query.

The solution provided by sintek worked but with a few discrepencies but jindon's solution worked virtually perfectly.

I've updated the sample with jindons macro that shows a tiny issue with the data for the HP Pavilion X2's on lines 21 & 24-27 but as these were not in the original sample this is totally my fault.

Thx again guys for all your efforts

[jindon]

JohnnyBoyxxx

I also need the results that you want...

[jindon]

I've updated the sample with jindons macro that shows a tiny issue with the data for the HP Pavilion X2's on lines 21 & 24-27 but as these were not in the original sample this is totally my fault.

Since you didn't show me the result that you want, tihis is only my guess.
Change pattern to

Please Login or Register  to view this content.

[JohnnyBoyxxx]

Hi Jindon,
My apologies, i've updated the sample sheet and you'll notice the formula brings in the results for HP Pavilion X2 lke row 24. The results i'm hoping for are on row 25 and 26.

Regards
John

[jindon]

What about row 21?
Is it for series of "HP Pavilion" only?

[JohnnyBoyxxx]

The code for row 25-26 is what it should look like, rows 21 and 24 is what the formula gives me. The X2 is not part of the code and only represents a model type.
We have other HP Pavilions that do not have the X2 in their description and the formula works fine for them.

What you've provided me with so far sorts over 95% of my product range so i'm really happy, a real time saver so many many thanks.

It is only a few products that have this issue and I really don't mind the odd manual adjustment, I feel i've taken enough of your time.

regards
John

[jindon]

Try this one

Please Login or Register  to view this content.

[JohnnyBoyxxx]

Works a treat, absolutely brilliant time saver for me.

Thank you very much for everything

Regards
John

[jindon]

You are welcome and any further adjustment in future, just post back.