Special characters

R

Rick

In Office 2003/Excel, how can I Find and Replace Special
Characters, like a Hard Return left by another
version/product?
 
G

Gord Dibben

Rick

Hard reurns are usually 0010.

Try Edit>Replace

What: ALT + 0100
With: nothing or a space(your choice)

Gord Dibben Excel MVP
 

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

Find and replace macro for Special ^p - MS Word 0
Lower-Case Characters 2
Outlook 365 - How to access and edit special IMAP folders path? 0
replace 5
Problem with MS Word paragraph and character styles: format getting messed up 2
Special characters 3
Disable Outlook AutoCorrect with GPO 0
Fixing attributes special paste 1

Top