need a macro.
this is the sample of my spreadsheet.
column
A B C
-----------------------------------------
N001 numbers
N002 numbers
N003 numbers 101
N004 day numbers
N005 day numbers
N006 day numbers
N007 day numbers
this is sample what I need to replaced.
column
A B C
-----------------------------------------
N001 yes text
N002 yes text
N003 no text 101
N004 day text
N005 day text
N006 day text
N007 day text
pls help for create a macro.
|