Importing from Filemaker Pro 5.0

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I am in the process of converting a Filemaker Pro
database to Excel 2000. When I export a field in
Filemaker with hard returns in it, the result is this
little "arrow symbol" (see 4 examples below).

Plate of ocean water Plate of HELO BG Plate of Sky
(Note: Possible Night Sky Backing)

I can't do a Find/Replace because Excel doesn't recognize
this symbol. Any clues how to easily delete them, and
insert a hard return instead within one cell(alt/enter)?
I tried exporting to html first and then converting to
excel, but it created a new row for each return. I need
all data in one cell, left formatted with returns where
the "arrow symbol" is.

Thanks!
 
Still don't know how to replace the symbol but figured
out that the function "Clean" will take them out.
 

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

Back
Top