Hi,
I need an excel formula to extract the string of text in column A. The output should be the same in column B.
Thanks,
Lay
I need an excel formula to extract the string of text in column A. The output should be the same in column B.
Book7 | ||||
---|---|---|---|---|
A | B | |||
1 | DESCRIPTION | OUTPUT | ||
2 | BKOFAMERICA ATM 01/24 #000003704 WITHDRWL BOLINGBROOK BOLINGBROOK IL | BANK OF AMERICA | ||
3 | CHASE CREDIT CRD DES:EPAY ID:3917523958 INDN:JOSE L ROMAN CO ID:5760039224 WEB | CREDIT CARD | ||
4 | CHECKCARD 0101 UNLIMITED VACATIO 8779232582 65130199002000000052690 CKCD 7011 XXXXXXXXXXXX3266 XXXX XXXX XXXX 3266 | UNLIMITED VACATIO | ||
5 | External transfer fee - 3 Day - 01/15/2019 | BANK OF AMERICA | ||
6 | External transfer fee - Next Day - 01/07/2019 | BANK OF AMERICA | ||
7 | Online Banking transfer to CHK 0963 Confirmation# 1471021507 | CHK 0963 | ||
8 | Online Banking transfer to CHK 7605 Confirmation# 2357046919 | CHK 7605 | ||
9 | TRANSFER INTEGRATED TECHNOLOG:A7A TELECOM INC Confirmation# 0486301605 | A7A TELECOM INC | ||
10 | WIRE TYPE:WIRE OUT DATE:190118 TIME:1508 ET TRN:2019011800397098 SERVICE REF:012771 BNF:LEO A. PALMER III ID:525032129 BNF BK:JPMORGAN CHASE BANK, NA ID:075000019 PMT DET:252857794 WEE KENDING 11219 | LEE A. PALMER III | ||
11 | BEST BUY DES:PAYMENT ID:212836450670095 INDN:CHRISTIAN ABALA CO ID:CITIGPUFDR TEL | BEST BUY | ||
12 | PRUDENTIAL DES:INS PREM ID:2L9641160019025 INDN:CHRISTIAN ABALA CO ID:9478857501 PPD | PRUDENTIAL | ||
Sheet1 |
Thanks,
Lay