Dave

Select your column and choose Data, Text to Columns. Click
OK for the first screen. Choose Other separator on the
second and enter / in the check box.

The slash is removed and the data is separated.

Regards
Peter
-----Original 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

.