Forum Discussion
Verushka
Jan 05, 2023Copper Contributor
Show special hidden characters in excel
Hi, how do I make excel show hidden characters, such as spaces, line breaks or paragraph breaks, like in Word? Thanks
Verushka
Jan 05, 2023Copper Contributor
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.
HansVogelaar
Jan 05, 2023MVP
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.