Thread: Long character string - need to remove part of it
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
laralea laralea is offline
external usenet poster
  
Posts: 12
Default Long character string - need to remove part of it
For example:

I need this...
/USA/NORTH CAROLINA/MOORESBORO/CLIFFSIDE STEAM STATION, MOORESB/CLIFFSIDE #5
SHOP-WAREHOUSE/001/0141/

to look like this...
/USA/NORTH CAROLINA/MOORESBORO/CLIFFSIDE STEAM STATION, MOORESB/

Is there code that will do this? Also, there are 56,000 records and the data
baries slight in the different records.

Reply With QuoteReply With Quote