Doesn't work for me.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ashish Mathur" wrote in message
...
Hi,

You may try an array formula (Ctrl+Shift+Enter)


1*MID(A14,MATCH(TRUE,ISNUMBER(1*MID(A14,ROW($1:$19 ),1)),0),COUNT(1*MID(A14,R
OW($1:$19),1))+IF(ISNUMBER(MATCH(".",MID(A14,ROW($ 1:$19),1),0)),1,0))

This formula assumes that the reference cell is A14

Regards,

Ashish Mathur

"Cathy Landry" wrote:

Hello,

I have a drop down list of names/addresses. Within this list is a
center
number preceded by a "#". I'd to be able to pull the actual center#
i.e.
3325 to populate into my cost center cell.

25TH STREET Center# 3325 (old 0325)
920 East 25th St
Baltimore MD 21218

Is this possible?

Thank you!
Cathy