Thread: Separating Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveB[_2_] DaveB[_2_] is offline
external usenet poster
 
Posts: 5
Default Separating Data

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