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
Spell number in excel without macro - Guide
Extract audio from video vlc - Guide
Excel macro to create new sheet based on value in cells - Guide
Macro excel download - Download - Spreadsheets
Automatically run a macro when opening a worksheet - 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

kmspico password protected

Converting rows of data in notepad to columns

Code for macro that conditionally inserts rows

VBA find column by name and sort

Similar discussions

Subscribe To Our Newsletter!