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