Jump to content

Export to Excel - paragraph marks


This topic is 7201 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am exporting a file to excel. A single field in FM appears as follows (there are reasons why this cannot be separated). When importing to Excel a small box appears after each line, I assume this is a symbol for paragraph mark. Any way to remove these?

226 Seismology

LDEO

PO Box 1000

61 Route 9W

Link to comment
Share on other sites

Returns in a field are converted to 'vertical tabs' when exported. The reason for that is that returns are the End-Of-Record charachter in most formats. That 'vertical tab' character is the one Excel has trouble with.

Probably the best way to get rid of them is to create an Excel macro to clean out those stray characters. You need VBA for that...

HTH

Wim

Link to comment
Share on other sites

Hi Wim,

This may be off the wall, because I'm on a Mac and don't have a way to test it, but couldn't you capture one of the characters, and then use Excel built in find and replace.

Just a idea,

Lee

Link to comment
Share on other sites

This topic is 7201 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.