Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Painter button problem | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
cut and paste format problem | Excel Discussion (Misc queries) | |||
cell format problem | Excel Discussion (Misc queries) |