Can someone help me with my excel workbook problem please?

[Caymen Hammond]

I am working on the following workbook Notes.xlsx but can't seem to get working.

What I need the program to do is:

1. Take two sentences or paragraphs and make them into one
2. I need the paragraphs and sentences to be punctuated correctly
3. There can't be any spaces between the paragraphs
4. If a paragraph has bullet points then I need the bullet points converted into a list with each item separated using a semicolon rather than bullet points.
5. Sentence case and all punctuation needs to be correct and is a high priority that it is correct

The reason for this program is because the excel database our work company has designed does not allow new line spaces meaning spaces in between paragraphs for notes or extra lines for each bullet points aren't allowed. Meaning an error occurs in the system when it is inputted.

 

[Radoslaw Poprawski]

from where do you import your text?
This might be easier-doable in PQ, if you point to proper link with unchanged data.

 

[Caymen Hammond]

from where do you import your text?
This might be easier-doable in PQ, if you point to proper link with unchanged data.

Community nursing service episode—goal of care, code NN here is an example, code 2 notes is what I am aiming to be in one paragraph. No extra line spaces and no extra lines for bullet points.

 

[Peter_SSs]

Duplicate to: How to add a capital letter after a full stop in excel

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.