EXCEL: Add Symbol at End of Each Paragraph Within Text Wrap Line, Avoid Splitting Words

Hello,

I need to add a symbol at the end of each line (paragraph) in the line. I know how to add a symbol to the end of each line, but sometimes it happens that a given line consists of several lines (paragraphs) - separated by the text wrap tool. I will just add that each line can have a maximum of 60 words.
I tried to make a function that inserts a given character after 60 words, but I don't want a given character to split a word in half.

Sample text of one line:

Wash your hands with soap
After washing, wipe your hands clean
they dry.

I want the line to look like this after formatting

Wash your hands with soap * /
After washing your hands, wipe your hands so that they are * /
they are dry * /

I will be very grateful for your help.

= SUBST (SUB (A1; "."; "* /"); CHAR (10); "* /" & CHAR (10))
Seems so
but better see the attachment for a sample sheet.

Thank you for the information. Unfortunately, the given formula only works if you manually separate the text by using the shortcut Alt + Enter. Depends the formula would work after using the replace text button. Please see the attached file.

The simplest solution is to give all cells with text custom formatting to :ok:

You will get the effect as in the screenshot:
2017-09...png Download (35.05 kB)

Thank you for the information. Unfortunately, such formatting introduces the given character at the end of the entire line, not at the end of each paragraph (line) in the line ...

You can get a similar effect to the expected by using a formula that will be rigid divided texts from the cell, e.g. into 5 lines (paragraphs?) - see screenshot
2017-09-1..1).png Download (74.37 kB)

On the other hand, what practical sense of these "flags" in the text perhaps could be solved in a different way?

It is about proper formatting of the text, which is automatically uploaded to SAP. Excel users enter their own text, which is then automatically uploaded to SAP by clicking a button. The problem is that SAP does not accept a paragraph longer than 60 characters and rejects the text. However, if at the end of each line the mentioned early symbol is added, then SAP treats it as Excel Alt + Enter and elegantly copies everything.
Currently, in Excel, I have a fixed line width and each user knows that at the end of each line, the symbol must be manually entered. The problem is that it is quite time-consuming ... and that's why I am looking for a solution.

unless a user function (UDF)

Cool! Thank you very much! Works perfectly