I have returned. Try as I might I cannot seem to get any one formula to return the information I need. This time I have attached the actual full spreadsheet.

Some of the transaction information supplied by the bank has business names on the left.

BANGKOK PEPPERS GRAND BLANC MI*01-22-15*254538
BARE ESCENTUALS #04 CHICAGO IL*01-01-15*824498
BINNYS BEVERAGE DEP GLEN ELLYN IL*11-28-14*973297
BRICKS WOOD FIRED WHEATON IL*12-03-14*147324
BUZZ CAFE OAK PARK IL*01-02-15*505295

Some of the transaction information supplied by the bank has business names on the right:

POS 1228 1958 314064 AMAZON.COM SEATTLE WA
POS 1230 1632 317823 MENARDS- GLENDALE H GLENDALE HEIGIL
POS 1231 1340 319625 Marianos FRESH WHEATON IL

Some of the transaction information supplied by the bank has only address information:

POS 1213 2202 283981 142 OAKBROOK CENTER OAKBROOK IL
POS 1217 1903 291775 505 W ARMY TRAIL RD BLOOMINGDALE IL
POS 1218 1923 293986 2031 MAIN ST. WHEATON IL
POS 1219 2010 296746 360 W ARMY TRAIL RD BLOOMINGDALE IL

Given the nature of the data supplied it I cannot only look to the left for data, or the right, or the middle for a match. It seems I need one that finds a matching pattern of characters of a certain length regardless where they fall in the cell. In my imagination the above supplied data would find matched segments:

142 OAKBROOK CE
505 W ARMY TRAI
2031 MAIN ST. WH
360 W ARMY TRAI
BANGKOK PEPPERS
BARE ESCENTUALS
BINNYS BEVERAGE
BRICKS WOOD FIR
BUZZ CAFE OAK P
AMAZON.COM SEAT
MENARDS- GLENDA
Marianos FRESH


Mind you, I really have no idea how to do this and look forward to trying to understand the responses given, reverse engineering.

Thanks in advance.BankStatementRealSample.xlsx