Replace

[koba]

Hello Everyone


When i highlight a colum and use the replace fuction how do i replace
the whole number 4 with the number 2, because currently it replaces all
the number in everything such as the cell that has 48 goes to 28?

Please help

Andrew

 

[Norman Jones]

Hi Koba,

Select the 'Find entire cells only' option.

 

[koba]

thank you worked a trea