Please let me know how I can write a macro in excel to replace a value in
each cell of the entire column example.

in column B

'1' - replaced with 'Invoice'
'C' - replaced with 'Credit note'

I dont not mean in menu - Find - Replace .

With thanks
Pol