| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace
Hi Koba,
Select the 'Find entire cells only' option. --- Regards, Norman "koba" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace
thank you worked a treat -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 View this thread: http://www.excelforum.com/showthread...hreadid=487831 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find replace format | Excel Discussion (Misc queries) | |||
| Search and replace | Excel Worksheet Functions | |||
| replace absolute references | Excel Worksheet Functions | |||
| REPLACE outside of highlighted column | Excel Worksheet Functions | |||
| Replace Number with Text using Macro | Excel Discussion (Misc queries) | |||
Linear Mode
