Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a *.csv address file in excel page format. All the records resides in
column A:A and each line consists of max 55 info bits seperarted by commas. The first line contains the 55 headers seperated by commas and all of the remaining long line list the data. I need to remove all data from each line except the combination of the first and third element of data, a comma, and then the fifth data item. Say the data lines look like this: Adam, Martyn, Smith, pal, , bla, bla, bla,...... Frank, , Mandy, friend, , bla, bla,..... ....... I need to achieve this as my *.csv file: Adam Smith, Frank Mandy, ..... What is the best way to do it? Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Password protecting file (modifying) with a slight twist | Excel Discussion (Misc queries) | |||
Modifying a Excel file without opening excel | Excel Discussion (Misc queries) | |||
Large file sizes after modifying spreadsheet in Excel 2007. | Excel Discussion (Misc queries) | |||
Modifying an Old Excel Macro | Excel Programming |