Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove ' at beginning of cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove ' at beginning of cell
If all your fomulas are within a column, try this:
1. Highlight the column 2. Data - Text to Column 3. Choose Delimited and Next 4. Click Other: then key in ' 5. Click Finish Hope this help -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |