Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Junk Characters in Excel Documents

I have problem in Excel files which i recoverd from the Formatted Hard disk
specially the 2048 kb size has junk character
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 373
Default Junk Characters in Excel Documents

Easy to do using Find manually.
1. Select the cell containing the junk character.
2. In the formula bar, select the junk character (it may look different in
the formula, but you can tell by its position)
3. With the junk character selected, press Ctrl-c
4. Press Esc to exit edit mode
5. Press Ctrl-h to show Find and Replace
6. Put the cursor in the Find What box and press Ctrl-v
7. Leave the Replace with box empty
8. If you don't see options Match Case and Match Entire Cell Contents,
click Options to show them. Make sure neither one is checked.
9. Click Replace All
10. Repeat for other junk characters.
11. Save the file
HTH, James
"Alvan" wrote in message
...
I have problem in Excel files which i recoverd from the Formatted Hard disk
specially the 2048 kb size has junk character



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can't I open excel documents? BannockBurner Setting up and Configuration of Excel 2 January 29th 06 01:31 PM
excel documents won't open from my documents folder Paul1961 Excel Discussion (Misc queries) 2 January 15th 06 05:31 PM
In Excel find characters when multiple characters exist w/i a cel teacher-deburg Excel Worksheet Functions 1 December 5th 05 10:22 PM
Excel Documents Don't Appear in My Recent Documents Addi Excel Discussion (Misc queries) 4 July 24th 05 09:43 PM
delete blocked senders messages on receipt why junk mail them? yralih Excel Discussion (Misc queries) 1 July 17th 05 01:09 AM


All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"