Hi everyone!

I was wondering if you cound help with a problem I'm having with Excel. I
have a list of codes that I want Excel to save in txt format with the "".
I'll explain: I have thousands of codes in a numerical format (e.g. 3173471;
3174742, etc.) but I need to save a txt file that puts "" around the value,
i.e., "3173471", "3174742", etc. I've tried to use the concatenate function,
replace and even tried to program a macro (I'm not that procient in macros,
so something could be wrong...) but nothing worked. The best i could was
using the replace function and, in fact, in Excel it looked as if everything
was correct, i.e., i saw "3174742", . However, when I saved it to txt I got
this weird result: """3173471""". I could try to make the replacement in word
or notepad, but given the huge amount of files I'm using this would be to
cumbersome.
Does anyone has an idea how I could get around this?

Cheers,

Nuno

See:

http://www.mcgimpsey.com/excel/textfiles.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi everyone!

I was wondering if you cound help with a problem I'm
having with Excel. I
have a list of codes that I want Excel to save in txt
format with the "".
I'll explain: I have thousands of codes in a numerical
format (e.g. 3173471;
3174742, etc.) but I need to save a txt file that
puts "" around the value,
i.e., "3173471", "3174742", etc. I've tried to use the
concatenate function,
replace and even tried to program a macro (I'm not that
procient in macros,
so something could be wrong...) but nothing worked. The
best i could was
using the replace function and, in fact, in Excel it
looked as if everything
was correct, i.e., i saw "3174742", . However, when I
saved it to txt I got
this weird result: """3173471""". I could try to make
the replacement in word
or notepad, but given the huge amount of files I'm using
this would be to
cumbersome.
Does anyone has an idea how I could get around this?

Cheers,

Nuno
.