Show special hidden characters in excel

New Contributor

Hi, how do I make excel show hidden characters, such as spaces, line breaks or paragraph breaks, like in Word? Thanks

3 Replies

@Verushka 

You can't - Excel doesn't have an option for displaying non-printing characters.

Thanks, that was a fast and definite answer. so how do you find and replace special characters in excel? It would be nice to have that option.

@Verushka 

To find a space, simply enter a space in the 'Find what' box in the Find dialog (Ctrl+F) or Replace dialog (Ctrl+H).

To find a line break, click in the 'Find what' box and press Ctrl+J.

Excel does not have paragraph breaks.