| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to correct copied option tickers starting with "+"
I copy financial data from my brokers website and paste it as text into a
spreadsheet. Look-up formulas reference the downloaded information. My Broker precedes option tickers with a + sign, and Excel thinks that it is a formula. Example: The copied text +EDTG, is displayed in the formula bar as =+EDTG and the cell shows the #NAME? error. I currently use the replace tool to remove the =+ operators, which makes the entry usable, but would like to know if there is a way to do this with a formula. Any help is greatly appreciated. BTW, I use Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I "insert copied cells"? used to be "alt i e" still work | Excel Worksheet Functions | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| How do I replace decimals starting with "." to "0." in excel? | Excel Discussion (Misc queries) | |||
| Need correct IF(ISBLANK) formula when referencing whether one of twocells (OR) is blank, returning "no value" | Excel Worksheet Functions | |||
| Simple? Formula for "for the week starting Monday May Xxth" | Excel Worksheet Functions | |||
Threaded Mode
