View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JN
 
Posts: n/a
Default Look up/math text

Hi,

I am trying to match up a list of accounts (table A) from a huge text table
(table B). The problem is table A doesn't have the same format as the text
strings in table B. The text in table A contains part of the text strings in
table B.

For example,
Table A has 01A0000
Table B has ST1A0000

Thx!