Help with Macro

[Abbey Normal]

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.

 

[Gord Dibben]

See the post you tacked onto.

http://tinyurl.com/2xcj73

Is that what you are referring to?


Gord Dibben MS Excel MVP

 

[Abbey Normal]

Actually, that one is working for me. Thanks, now my question(s) are:
1. is there a way I can make this easy for the user to do? or automate it
somewhat?
I am sending her a CSV file via email as an on-request basis, when she ships
to that customer, so she will have to fiddle with this spreadsheet everytime.
2. Is there also a way to format a column as text first? If i don't do that
before I run the macro, the number is replaced in scientific notation.
Thanks for any help you can provide....

 

[Abbey Normal]

I just saw your other post regarding the personal.xls worksheet, and that
works just fine for me. Now the only other question i have is can is there a
way I can have a macro auto'lly change the format of a column to text so this
macro wont change it to sci notation? Thanks a whole bunch!

 

[Gord Dibben]

Make change to one line

c.Value = "'" & re.Replace(c.Text, "")

That adds an apostrophe to each cell.


Gord