Help please

Status
Not open for further replies.

Caymen Hammond

New Member
Joined
Jun 20, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows
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.

Here is a real-life example (Community nursing service episode—goal of care, code NN 2 needs to be in one paragraph as the access syatem I copy the notes into dosen't allow spaces, bullet points, new lines, etc.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Status
Not open for further replies.

Forum statistics

Threads
1,148,187
Messages
5,745,230
Members
423,936
Latest member
Conservatopia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top