| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup (Source data has a non-visable character) Excel
I've got a vlookup challenge that I'm not sure how to overcome. I must manually click on the source cell which is a seven digit number and move the cursor to the right of the number (XXXXXXX)|(Click Delete) then the vlookup will work. I've tried to copy and paste values only. I've tried to use the Left or Right command to just bring over the 7 characters and trim. There appers to be something to the right that needs to be moved or deleted. Any ideas? Thanks, -- Credit Law Guy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't vlookup read newly entered data from a source file? | Excel Discussion (Misc queries) | |||
| Print Visable Data Only | Excel Worksheet Functions | |||
| Print Visable Data Only | New Users to Excel | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Excel Worksheet Functions | |||
Threaded Mode
