| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup functions which could not recognise similar alphanumerics
I would like to find out why alphanumerics, e.g 14.02F100034 in separate
columns are not detected and hence "#N/A" was displayed. The whole worksheet was copied and pasted from two separate worksheet and superimposed. I thought that by formatting cells to GENERAL and pasting these data choosing PASTE Specials with just Values Only would do the trick, and it failed. Please advise what could be done to rectify the problems as the whole data contains about more than 5000 rows of information. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Vlookup help ... or something similar | Excel Worksheet Functions | |||
| Similar to Vlookup | Excel Discussion (Misc queries) | |||
| How many similar functions can be put in one cell? | Excel Worksheet Functions | |||
| Ignore Non-Alphanumerics When Comparing Text | Excel Worksheet Functions | |||
| Average using alphanumerics | Excel Worksheet Functions | |||
Threaded Mode
