Macro to extract to a new column

Closed
ty - Mar 15, 2010 at 05:08 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 01:30 PM
Hello,
I need help with a excel formula, as follows

HP LASERJET 4250/4350 HI TONER CARTRIDGE
HP #78 TRI COLOUR INK CARTRIDGE (19ml)
HP #98 LASERJET BLACK TONER CARTRIDGE

I need to extract to a new column i.e Colour , where it says black i need to extract Mono and where its is blank I need to extract in new column Mono.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 15, 2010 at 01:30 PM
Not sure what you seek, but from what i could get

=IF(NOT(ISERROR(SEARCH("BLACK",A1,1))),"BLACK",IF(NOT(ISERROR(SEARCH("COLOUR",A1,1))),"COLOUR","mono"))
0