Hi Bob,

I figured out the answer to my last question to you. This is what I used.

=IF(ISBLANK(F18),"",MID($J$6,FIND("# ",$J$6)+2,FIND(" ",$J$6,FIND("#
",$J$6)+2)-FIND("# ",$J$6)-2))

Thank you again.........it works beautifully!



"Bob Phillips" wrote:

Hi Cathy,

Is this okay?

=MID(A20,FIND("# ",A20)+2,FIND(" ",A20,FIND("# ",A20)+2)-FIND("# ",A20)-2)

--

HTH

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


"Cathy Landry" wrote in message
...
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