Remove Hard Return

  • Thread starter Thread starter Alice
  • Start date Start date
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
 
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
 
Back
Top