Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Long character string - need to remove part of it
more examples of the variables
-- Don Guillett SalesAid Software "laralea" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Long character string - need to remove part of it
On Tue, 14 Mar 2006 11:55:33 -0800, laralea
wrote: 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. What are the rules that determine how much of the string you wish to keep? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove special character at end of string | Excel Discussion (Misc queries) | |||
remove last character in a series of different length part #'s | Excel Discussion (Misc queries) | |||
Remove all characters following the first character in a string | Excel Discussion (Misc queries) | |||
remove last part of string | Excel Programming | |||
Remove part of string | Excel Programming |