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
How to delete a column in word - Guide
Extract audio from video vlc - Guide
Macro for number to words in excel - Guide
Vba select column by name ✓ - Excel Forum
How do i auto number a column in excel? ✓ - Excel Forum

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?

I need a password for this kmspico files

New password

kmspico password protected

Have downloaded KMSPico but I need the password

Similar discussions

Subscribe To Our Newsletter!