strip commas out of memo field

[ecugrad]

I have a word template containg numerous fields. The template writes data entered into a comma delimited text file which is then uploaded to a database. My problem is that I have two free form memo fields that the users can place commas and other characters into.

My question is how can I strip the commas out of my memo field before I write the data to my text file for upload..

Thanks,

Mike

 

[Andrew Fergus]

Hello and welcome to MrExcel. Which application are you wanting to use to strip the commas out of the memo field?
Andrew