J jpen Active Member Joined Jun 19, 2002 Messages 393 Sep 13, 2002 #1 Hi All, I have a txt file which I import in Excel for further analyses. Only in the txt file a point is used for number seperation. Will I work with a comma. How can I change this by using a macro? Thanks
Hi All, I have a txt file which I import in Excel for further analyses. Only in the txt file a point is used for number seperation. Will I work with a comma. How can I change this by using a macro? Thanks
Andrew Poulsom MrExcel MVP Joined Jul 21, 2002 Messages 73,092 Sep 13, 2002 #2 See: http://www.mrexcel.com/board/viewtopic.php?topic=21936&forum=2
J jpen Active Member Joined Jun 19, 2002 Messages 393 Sep 13, 2002 #3 Andrew, I'am using Excel 97 and I don't find a "Advanced" button (step 3).
Andrew Poulsom MrExcel MVP Joined Jul 21, 2002 Messages 73,092 Sep 13, 2002 #4 Oh dear! One way is: 1. Select the data and choose Edit, Replace from the menu. Replace . with @ 2. Repeat, replacing , with . 3. Repeat replacing @ with , If you record your actions you will be able to automate it for future use.
Oh dear! One way is: 1. Select the data and choose Edit, Replace from the menu. Replace . with @ 2. Repeat, replacing , with . 3. Repeat replacing @ with , If you record your actions you will be able to automate it for future use.