View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Line breaks in my cells...

Try Alt + 0010 in the Find what dialog.

Use the NumPad to enter the 0010

To see which characters you have in a cell, download Chip Pearson's CellView
add-in.

http://www.cpearson.com/excel/CellView.htm



Gord Dibben MS Excel MVP

On Wed, 3 Oct 2007 04:41:01 -0700, AkelA
wrote:

Do you mean "^j"? I have a non-English version and Ctrl+J does not do
anything... For "^J" Excel returned no results.

Anyway, I managed to solve my problem with a little trick, but still I would
like to know. For future problems like this..... Btw, where can I find
reference for these special characters?