Parse LF-Delimited Column Text in Excel 2000?

[BJGAdmin]

I am trying to convert a dBase IV file (.dbf) to an Excel 2000 Spreadsheet.&nbsp;&nbsp;I can open the .dbf file and it converts fine, except for one particular column.&nbsp;&nbsp;This column has fields contained within it that are delimited with a &quot;manual line feed&quot; character.&nbsp;&nbsp;The character appears as a square in Excel.<br><br>Using the &quot;Convert Text to Columns Wizard&quot;, I cannot seem to specify a LF-character delimiter, nor can I copy the character and paste it into the &quot;Other Delimiter&quot; box.<br><br>Is there a way I can parse this column?&nbsp;&nbsp;Thank you very much for your help.<br><br><br>--&nbsp;&nbsp;Aaron Cutchin<br>--&nbsp;&nbsp;LAN Admin, BJG<br>--&nbsp;&nbsp;<A HREF="mailto:admin@bjg.com">admin@bjg.com</A><br><br>

 

[dsi]

What type of data does this column contain? Do you know the Ascii number that corresponds to the character you want removed? I can write a quick application that will remove or replace this character.<br><br>Or, if you know the ASCII number you can use the Edit&gt;Replace function in Excel. In the replace textbox hold the Alt Key down, type the ASCII number, then release the Alt Key. For example Alt-248 is the degree symbol. Then leave the replace with box empty to remove that character or enter a space to replace it with a space. <br><br>There are several ways this can be accomplished. Let me know if you need some more help.

 

[dsi]

Sorry, if this is a simple line feed you should try to use Alt-10. If this does not work, let me know.

 

[Dreamboat]

Aaron's problem was resolved some time ago. I emailed him that he should try to copy that column into Word, do a search and replace to find the &quot;line break&quot; character and replace it with nothing, then copy back into Excel. This worked for him. <p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>

 

[dsi]

Sorry, it still looked open.

 

[Dreamboat]

No problem, tclere. I like to post the answer anyway so &quot;listeners&quot; see it! Glad you posted. <p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>

 

[BJGAdmin]

Actually, I copied the cells to Word, 1000 at a time (there are 12,000 of them), and replaced the MLF character with a tilda (~).   I then recopied the cells into the excel spreadsheet and converted text to columns based on the tilda.  <b>Thank you all very much for your help!!!</b><br><br>Maybe you can advise me on another subject:  When I finally got all 12,000 contact records imported into an Outlook/Exchange contact folder, it takes almost 2 minutes to search!  Is there a way to speed this up?<br><br><br>--  Aaron Cutchin<br>--  LAN Admin, BJG

 

[dsi]

That sounds like an awful lot of contacts for Outlook. You may want to use a database of some kind for more efficient record searching. You should probably repost this as a new question to update the subject line with the hopes of attracting other users with expertise in this area.