Find values in Cells and separate in other Column

kamus45

New Member
Joined
Nov 17, 2017
Messages
16
Hi again Excel Experts, I was working in something and think that maybe you can help me to not to expend hours doing something like this


I have a Product name with certain values in column B like this:
All in One HP Pro One 600 G2 21.5” Intel Core i5-6500 8GB 1TB Windows 10 Pro
All in One Dell Optiplex 3050 19.5” Intel Core i3-7100T 4GB 500GB DVD Windows 10 Pro
All in One HP 205 G3 19.5” AMD E2-7110 1.8GHz 4GB 1TB DVD Gráficos Radeon R2 Windows 10 Pro

And if I find something like:
Celeron
Core i3
Core i5
AMD E2
AMD A6
Write this data to C column


And if I find something like:
4GB
8GB
12GB...
Write this data to D column


And if I find something like:
500GB
1TB
2TB...
Write this data to E column


And if I find something like:
18.5"
21.5"
23.8"...
Write this data to F column


And if I find something like:
Windows 10 Home
Windows 10 Pro
Linux...
Write this data to G column


I do this manually and maybe you know a way to do it easier, thanks for your help

KTsBteh


KTsBteh.jpg
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

István Hirsch

Well-known Member
Joined
May 16, 2013
Messages
1,634
Try this:

Excel Workbook
ABCDEFG
1ProcesadorMemoriaDisco DuroPantallaSistema Operativo
2All in One HP Pro One 600 G2 21.5 Intel Core i5-6500 8GB 1TB Windows 10 ProCore i58GB1TB21.5Windows 10 Pro
3All in One Dell Optiplex 3050 19.5 Intel Core i3-7100T 4GB 500GB DVD Windows 10 ProCore i34GB500GB19.5Windows 10 Pro
4All in One HP 205 G3 19.5 AMD E2-7110 1.8GHz 4GB 1TB DVD Grficos Radeon R2 Windows 10 ProAMD E24GB1TB19.5Windows 10 Pro
5All in One HP 205 G3 19.5 AMD E2-7110 1.8GHz 4GB 1TB DVD Grficos Radeon R2 LinuxAMD E24GB1TB19.5Linux
Sheet1
 

kamus45

New Member
Joined
Nov 17, 2017
Messages
16
Hi, thanks for reply, I try the code but get error

e9EfJ3H.jpg


Is any way to make the search according to a range of data? example I got in Specs worksheet the probable data in C (Procesadores), D (Memorias), E (Disco Duro).....

this is the file that I'm using:

Code:
https://www.mediafire.com/file/51hd1pf72bbsekr/Test.xlsx
 

István Hirsch

Well-known Member
Joined
May 16, 2013
Messages
1,634
If you are not using the English language excel version, you should "translate" the formula to your excel version and use the proper argument separator.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,551
Messages
5,636,965
Members
416,952
Latest member
prakashkumar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top