Download to Excel: How to remove apostrophe?

D

DCPan

Hi,

I did some searches on older threads and can't seem to find an answer to this.

I have an access db that compares data from a couple of sources, then
download a spreadsheet of new entries that needs to be manually entered into
an enterprise system.

You would think that those entries could just be copy and pasted into the
GUI, but for some strange reasons, there are leading apostrophe in the
download, even if it is already text.

For example, if the cell in access is "Superman", the downloaded Excel cell
would contain " 'Superman ".

I understand apostrophe is used to store number as text. But why have
apostrophe when it is already text?

Thanks!
 
L

Linq Adams via AccessMonster.com

Don't know why the apostrophe if it's already text, but as to the how I jsut
answered the same question on another forum! Do you perhaps lurk elsewhere?

You don't say where you're trying to do this, but in Access/VBA the general
way to strip a leading apostrophe would be

If Left(Me.OriginalCell, 1) = "'" Then
Me.OriginalCell = Right(Me.OriginalCell, Len(Me.OriginalCell) - 1)
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top