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.


---
Regards,
Norman


"koba" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> koba
> ------------------------------------------------------------------------
> koba's Profile:
> http://www.excelforum.com/member.php...o&userid=28639
> View this thread: http://www.excelforum.com/showthread...hreadid=487831
>

[koba]

thank you worked a treat