Solved: Remove ' from text

[Djblois]

At my company when we import data to Excel from our Database there is a leading ' on every cell. If you do a texttocolumns it will get rid of the ' in front of any numbers but not in front of any text. You also can not do a find and replace ' with a blank. Does anyone know how to get rid of the ' in front of the text? we tried trim and clean functions. Please help, it is annoying.

[grichey]

Are you just hitting import accept accept accept etc and not paying attention to the type of data imported? This happens if excel tries to preserve your data.

[grichey]

Also check the KB. This here thanks to ZB is exactly what you're trying to do http://www.vbaexpress.com/kb/getarticle.php?kb_id=109

[Djblois]

there is no choice with the way we import it. The DBMA exports it right to excel and gives no options for the type of data.

[Djblois]

that code worked. Thank you

[grichey]

mark as solved bitte