PDA

View Full Version : Solved: Remove ' from text



Djblois
06-16-2008, 08:21 AM
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
06-16-2008, 08:26 AM
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
06-16-2008, 08:28 AM
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
06-16-2008, 08:28 AM
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
06-16-2008, 08:46 AM
that code worked. Thank you

grichey
06-16-2008, 08:50 AM
mark as solved bitte