| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Applying a | delimiter to separate a series of Zip codes
Hello,
Using Excel 2002, I have a list of Zip codes (approx. 20,000) in the following format: 01005 01007 01008 01010 01011 01012 01026 01029 01031 01032 01033 01034 01035 01037 01038 01039 Etc.. I need to separate them by a | delimiter as follows: 01005|01007|01008|01010|01011|01012|01026|01029|01 031|01032|01033|01034|01035|01037|01038|01039|Etc. .. Is there a formula or a way? Thank you. Ed. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delimiter in CSV files | Excel Discussion (Misc queries) | |||
| How can you separate a series of numbers into jenks? | Excel Worksheet Functions | |||
| Separate values in cell by delimiter | Excel Discussion (Misc queries) | |||
| Applying range names to existing formulas in separate worksheets | Excel Discussion (Misc queries) | |||
| Tab Delimiter File | Excel Discussion (Misc queries) | |||
![Ed[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
