Macro to extract to a new column

Closed

ty - Mar 15, 2010 at 05:08 AM
rizvisa1 Posts 4478 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.

Macro to extract to a new column
Excel macro to create new sheet based on value in cells - Guide
Spell number in excel without macro - Guide
How to extract contacts from sim card - Guide
Macro excel download - Download - Spreadsheets
How to extract audio from messenger - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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"))

Similar discussions

Zip password :- what is the zip password?

New password

I need a password for this kmspico files

Auto generate serial number in excel based on Column

Similar discussions

Subscribe To Our Newsletter!