Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have problem in Excel files which i recoverd from the Formatted Hard disk
specially the 2048 kb size has junk character |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why can't I open excel documents? | Setting up and Configuration of Excel | |||
excel documents won't open from my documents folder | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
Excel Documents Don't Appear in My Recent Documents | Excel Discussion (Misc queries) | |||
delete blocked senders messages on receipt why junk mail them? | Excel Discussion (Misc queries) |