Windows 10: Search and Replace in Word and.or Excel

Windows 10 and Office 365

If I have a sentence in Word and I want to change a bit of text by adding something at the end of every sentence -
eg Old text. to read Old text. New text.
I can search for the paragraph marker using ^p and replace it with " New text.^p so that Old text.^p becomes Old text. New text.^p
My sentence is now Old text. New text.

I want to do the same with text in cells in a Word or Excel table, but I don't know what control character to use. It's not ^p. Can anyone tell me what it is at the end of text in each cell of Word and Excel? Word shows a small circle with 4 spikes (a mini Corona!); Excel doesn't show anything.

:)

 

Search and Replace in Word and.or Excel

Thanks Berton.
In Word you can use Find and Replace and select More then Special and there is a list of codes for Paragraph mark ^p, Manual line break ^l or Non-breaking space ^s and search for those. Using Word I could search for ^p at the end of a line of text in a cell then replace it with ^p new text^p
What I am looking for is something similar that was at the end of the text in an Excel cell that I could use in a similar way, but I don't think there is a paragraph break at the end of a line of text in an Excel spreadsheet.
I could convert the spreadsheet to Word, do the work there as detailed above and then convert back to Excel.

 

Search and Replace in Word and.or Excel

Windows 10 and Office 365

If I have a sentence in Word and I want to change a bit of text by adding something at the end of every sentence -
eg Old text. to read Old text. New text.
I can search for the paragraph marker using ^p and replace it with " New text.^p so that Old text.^p becomes Old text. New text.^p
My sentence is now Old text. New text.

I want to do the same with text in cells in a Word or Excel table, but I don't know what control character to use. It's not ^p. Can anyone tell me what it is at the end of text in each cell of Word and Excel? Word shows a small circle with 4 spikes (a mini Corona!); Excel doesn't show anything.

 

Search and Replace in Word and.or Excel

In WordPerfect it's Reveal Codes but check this page for Word:
Reveal Codes in Word (Microsoft Word)

For Excel this may help:
CODE in Excel (Formula, Examples) | How to Use CODE Function?