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.

need a macro.
 

What is the logic behind changing the original sample to the replaced sample?

i.e.

Why should the blanks change to yes or no?

Why should the numbers turn into text?


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 06:10:01 -0800, Johnny
wrote:

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.