Dave,

I'm not sure you need code, try this

Make sure you have a blank column next to your
range then:

Select your range containing the data
from the menu choose Data - Text to Columns
choose Delimited and hit next
under the delimiters heading choose Other and
type in a "/" (without quotes)
hit finish

Dan E

"DaveB" wrote in message ...
Hi...I have 4045 rows of data that look like this:

16TH FL BENN TOWER/4385
3900 CHESTNUT/6178

I need to separate out the 4 diget code after the /...so
it's in a column by itself. Can you help me with the code.

Thank you.

DaveB