| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit File Information
I have a .csv file with information in columns A,B,C, D. The information in column d is formated like this: AL Corp of Eng; ; 205-497-9828
I need to move the phone number into Column E, and delete the two simicolons. There is about 1200 rows of information that needs to be changed. Could someone show me how to do this? Thanks, Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listbox -shows table of information - option to select and edit ro | Excel Programming | |||
| How to Create a Macro to Edit a Variable Amount of Information | New Users to Excel | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
| i want to edit the same information in ten different files | Excel Worksheet Functions | |||
| Edit information in a cell and not change content | Excel Programming | |||
Threaded Mode
