Remove Hard Return

A

Alice

Exported contacts from Outlook 2003 in Excel format. Has vertical bars in cells (appears as box in "formula"). These represent "hard returns" from multi-line addresses. How can you remove?
Alice

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
B

Bernard Liengme

Copy a single character
Open the Edit | Find & Replace menu
Paste the character in Find What box
Enter a space in the Replace With box
Click replace all

best wishes
 

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

Similar Threads

Gray Scale Printing 2
Excel Macro --- personal.xls locked for editing 1
How to merge and compare 1
Change minus numbers to zero in cell 3
Excel formatting of lines 2
Excel Macro -- Stop Record Button 2
eXCEL 4
cannot center text, locked in align left mode? 0

Top