Sub Macro1()
Columns("A:A").Replace What:="I", Replacement:="Invoice", _
LookAt:=xlWhole, SearchOrder:=xlByRows
Columns("A:A").Replace What:="c", Replacement:="Credit Note", _
LookAt:=xlWhole, SearchOrder:=xlByRows
End Sub

Why dont you try recording one........
--
If this post helps click Yes
---------------
Jacob Skaria


"pol" wrote:

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