Find and Replace

[Iain Wicks]

Hi I want to replace the small square on my .dbf file
which I think is a carriage return. I open the file with
Excel and go to find and replace, BUT... i cannot remember
the keystrokes for the character.
Can anyone help

TIA

 

[Dave Peterson]

The alt-0010 also looks like a box character if wraptext is not enabled
(Format|Cells|Alignment tab).

Edit|Replace
Find what: Hit alt-0010 (from the numeric keypad--not above the QWERTY keys)
replace with: (leave empty or hit space bar--whatever you want.)

It may not look like the alt-0010 did anything, but try it.

I've never had good luck with the alt-0013 (carriage returns).

I'd use a macro:

Option Explicit
Sub testme()
With ActiveSheet
.Cells.Replace What:=Chr(13), Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End With
End Sub

You could use this with chr(10), too. (Change replacement:="" to what you
want (maybe a space character???).)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm