A large spread sheet contains one column that has the following info in
each cell. Each block of text contains a ten digit number that begins
with 00 and appears in a different place in the text. I need to write a
formula that will consistently pull the ten digit number to a new cell.
Any suggestions or help on an answer? thanks! Here is example!
*WIRE TYPE:WIRE IN DATE:072605 TIME:0740 CDT
TRN:050726010169 FEDREF/SEQ:3517452206JO/000373
RELATED REF:CAP OF 05/07/25 FED IMAD:0726B1QGC02C0003730726
ORIG:LAUNDRY SERVICES ID:2215462
SND BK:JPMORGAN CHASE BANK ID:0210423221
BNF:CLEAN CUT IRONING SERVICES ID:007654321
PAYMENT DETAILS: CAP OF 05/07/25
0012345678 - -SUSAN SMITH*


--
spectator
------------------------------------------------------------------------
spectator's Profile: http://www.excelforum.com/member.php...o&userid=25635
View this thread: http://www.excelforum.com/showthread...hreadid=390455

I can't see a 10 digit number in there, but assuming there is, try

=MID(A10,FIND("00",A10),10)

--
HTH

Bob Phillips

"spectator" wrote
in message ...

A large spread sheet contains one column that has the following info in
each cell. Each block of text contains a ten digit number that begins
with 00 and appears in a different place in the text. I need to write a
formula that will consistently pull the ten digit number to a new cell.
Any suggestions or help on an answer? thanks! Here is example!
*WIRE TYPE:WIRE IN DATE:072605 TIME:0740 CDT
TRN:050726010169 FEDREF/SEQ:3517452206JO/000373
RELATED REF:CAP OF 05/07/25 FED IMAD:0726B1QGC02C0003730726
ORIG:LAUNDRY SERVICES ID:2215462
SND BK:JPMORGAN CHASE BANK ID:0210423221
BNF:CLEAN CUT IRONING SERVICES ID:007654321
PAYMENT DETAILS: CAP OF 05/07/25
0012345678 - -SUSAN SMITH*


--
spectator
------------------------------------------------------------------------
spectator's Profile:
http://www.excelforum.com/member.php...o&userid=25635
View this thread: http://www.excelforum.com/showthread...hreadid=390455