I have data in column A and have to extract specific words which vary by rows TO COLUMN b
e.g SADC, EC1, EC2, EUR, EUR1,IOC, EC3, COMESA 1 , COMESA
Actually using formula for only one reference
Please Login or Register to view this content.
I have data in column A and have to extract specific words which vary by rows TO COLUMN b
e.g SADC, EC1, EC2, EUR, EUR1,IOC, EC3, COMESA 1 , COMESA
Actually using formula for only one reference
Please Login or Register to view this content.
Is it always going to be the third word?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
No , it varies between 3 to 6
Use lookup table for searchable values.
Enter formula in B2 and copy down
Formula:Please Login or Register to view this content.
v A B C 1 Articles Description Preferential Code Lookup Table 2 22041090 WINES SADC 3 22082090 BRANDY SADC (U117020) SADC EUR1 4 22082090 BRANDY SADC (U117020) SADC EC3 5 22083090 WHISKY (43%) COMESA 6 22084090 CANE CAPE SADC (U117020) SADC IOC 7 22084090 CANE CAPE SADC (U117020) SADC EC 8 22085021 GINS EUR1 (U117020) EUR1 EC2 9 22085021 GINS SADC (U117021) SADC EC1 10 22085021 GINS SADC (U117049) SADC COMESA 1 11 22085021 GINS COMESA (U117049) COMESA COMESA 2 12 22085021 GINS EC3 EC EC 1 13 22086010 VODKA COMESA 1 U117020) COMESA 1 14 22086010 VODKA SADC (U117020) SADC 15 22086010 VODKA SADC (U117020) SADC 16 22086010 VODKA COMESA 2 (U117020) COMESA 2 17 22086010 VODKA IOC (U117021) IOC 18 22086010 VODKA EC (U117049) EC 19 22086010 VODKA SADC (U117049) SADC 20 22086010 VODKA 21 22087019 LIQUEUR EC 1 (U117021) EC 1 22 22087019 LIQUEUR SADC (U117021) SADC 23 22087019 LIQUEUR EC2 (U117021) EC2
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Is that an error in A13 and should there be a "("
i.e should it be
22086010 VODKA COMESA 1 (U117020)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Right it should as below, typo error,somtimes it happens
22086010 VODKA COMESA 1 (U117020)
Here is another way. It should give you more accurate results
Must still use look up table.
Formula:Please Login or Register to view this content.
Last edited by AlKey; 02-16-2018 at 01:18 PM.
Thank you Alkey for solutions provided , Worked as requested
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks