Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |