| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETTING RID OF LEADING HASH MARKS
While attempting to use VLOOKUP THE LOOKUP VALUE IS 12345 the column that
has the list of values to be looked at has '12345 so it is not recognized and I get NA. The table I am working with has the ' attached to all of the entries in that column. Is there any way I can get rid of the hash mark so that my lookup will recognize the vale? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are hash tables in Excel possible? | Excel Discussion (Misc queries) | |||
| to get the relative marks from a table of names,subjects & marks? | Excel Worksheet Functions | |||
| Graph with large data range (hash marks on axis) | Excel Discussion (Misc queries) | |||
| Show hash marks instead of text | Excel Worksheet Functions | |||
| Hash marks in a chart | Charts and Charting in Excel | |||
Threaded Mode
