Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have spreadsheet in which I did some find and replace work on formulas. To the find and replace I had to put a ‘ before the formula making it text. This worked fine. I thought I could do a find and replace on the ‘ but the the find feature won't find the ‘. I have been doing - F2 key, home key, delete key, return key, to get back to formula. I have many cells and this is becoming tedious. Is there a way (an easy macro perhaps) to remove the ‘ in the cells? Thanks. JBE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search end/beginning of cell | Excel Discussion (Misc queries) | |||
How do I remove spaces at the beginning of cells? | Excel Discussion (Misc queries) | |||
Remove space at beginning of each name | Excel Discussion (Misc queries) | |||
Remove Spaces beginning Time entry | Excel Discussion (Misc queries) | |||
How do I remove a blanck space from the beginning of a formula? | Excel Worksheet Functions |