Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Replace" problems
I've copied a list of English suffixes ("-able", "-ation") etc. into a row
of my Excel worksheet. However, because the web-page table I copied them from has prefixed(!) each suffix with the equals sign, I'm getting the error #NAME? in each cell. When I click on the cell, I can see its contents, but not otherwise. I've tried using the replace function, but for the result I get, for instance: =-able+REPLACE("'='",1,1,"''") Can you help? Regards, Adetola Obembe. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Replace" problems
Try this:
Select the cells to be impacted From the Excel main menu: <edit<replace Find what: = Replace with: (leave this blank) Click the[Replace All] button Does that help? *********** Regards, Ron XL2002, WinXP "Adetola Obembe" wrote: I've copied a list of English suffixes ("-able", "-ation") etc. into a row of my Excel worksheet. However, because the web-page table I copied them from has prefixed(!) each suffix with the equals sign, I'm getting the error #NAME? in each cell. When I click on the cell, I can see its contents, but not otherwise. I've tried using the replace function, but for the result I get, for instance: =-able+REPLACE("'='",1,1,"''") Can you help? Regards, Adetola Obembe. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Replace" problems
Thanks, Ron. I was using the formulaic REPLACE. The more standard one you
pointed me to did the trick! Regards, Adetola. "Ron Coderre" wrote in message ... Try this: Select the cells to be impacted From the Excel main menu: <edit<replace Find what: = Replace with: (leave this blank) Click the[Replace All] button Does that help? *********** Regards, Ron XL2002, WinXP "Adetola Obembe" wrote: I've copied a list of English suffixes ("-able", "-ation") etc. into a row of my Excel worksheet. However, because the web-page table I copied them from has prefixed(!) each suffix with the equals sign, I'm getting the error #NAME? in each cell. When I click on the cell, I can see its contents, but not otherwise. I've tried using the replace function, but for the result I get, for instance: =-able+REPLACE("'='",1,1,"''") Can you help? Regards, Adetola Obembe. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
Named range causing really weird problems - HELP | Excel Discussion (Misc queries) | |||
2 Excel Problems that have been bugging me! | Excel Discussion (Misc queries) | |||
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
I'm getting mad - I'm having problems with EXCEL file name length | Excel Discussion (Misc queries) |