ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Saving changes made in excel (https://www.excelbanter.com/excel-worksheet-functions/214073-saving-changes-made-excel.html)

jjjtrio

Saving changes made in excel
 
I have a list of names and numbers in text format. I open or upload the file
in excel to filter out by area code. I need this new list to be saved in csv
or plain text doc. When I try to save the new list in one of these formats, I
loose what I have filtered out it is the same as the original file.

The only way I found to save the changes I'v made is to save as excel
workbook, but it is .xlxs format which i can't use.

Thanks in advance
Jarodd

David Biddulph[_2_]

Saving changes made in excel
 
Delete the stuff that you want to filter out, then save as csv or txt.
Or copy the stuff that is filtered in to another sheet, and save from that
to the csv or txt.
--
David Biddulph

"jjjtrio" wrote in message
...
I have a list of names and numbers in text format. I open or upload the
file
in excel to filter out by area code. I need this new list to be saved in
csv
or plain text doc. When I try to save the new list in one of these
formats, I
loose what I have filtered out it is the same as the original file.

The only way I found to save the changes I'v made is to save as excel
workbook, but it is .xlxs format which i can't use.

Thanks in advance
Jarodd




jjjtrio

Saving changes made in excel
 
I need to keep the data base to use for future lists. should I try to use
access?

"David Biddulph" wrote:

Delete the stuff that you want to filter out, then save as csv or txt.
Or copy the stuff that is filtered in to another sheet, and save from that
to the csv or txt.
--
David Biddulph

"jjjtrio" wrote in message
...
I have a list of names and numbers in text format. I open or upload the
file
in excel to filter out by area code. I need this new list to be saved in
csv
or plain text doc. When I try to save the new list in one of these
formats, I
loose what I have filtered out it is the same as the original file.

The only way I found to save the changes I'v made is to save as excel
workbook, but it is .xlxs format which i can't use.

Thanks in advance
Jarodd






All times are GMT +1. The time now is 05:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com