| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to replace this character ...
Hi
Recently I received a huge list of customers (around 3000) from my accounts department. This excel document contains 2 columns, viz Customer & Address. I am supposed to export this data to another system The problem is this address column contains actually 4 fields (Door No, Name, City & County). All these fields are concatenated with a square symbol (unable to copy & paste that symbol) and pasted into the Address column. I think this symbol is carriage return character. Now I want to split this particular column into 4 separate columns mentioned above How can I do this? Can someone let me know please.. Thanks in advance Harish Mohanbabu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace only the first character | Excel Discussion (Misc queries) | |||
| Character search and replace | Excel Worksheet Functions | |||
| Replace nonprinting character | Excel Worksheet Functions | |||
| replace new line character | Excel Discussion (Misc queries) | |||
| How do I replace a character with another? | Excel Discussion (Misc queries) | |||
Threaded Mode
