G
Guest
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
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