Unfortunately when you export out data, Excel will format the text characters in the Notes column as shown in the example below:  



This issue is with the way that Excel displays characters and is not an issue with our CRM software.


To get around this issue you can go into your Excel spreadsheet that you have exported out and use the Find and Replace function as shown below in red: 



How to remove the formatted text from the Notes column: 

1. Open up your spreadsheet and go to the Notes section of the spreadsheet as indicated in the screen-shot above.


2. Next click on the Find & Select icon which you will see along the top menu bar of Excel (as shown above).


3. You can choose the ‘Replace’ option which allows you to find text that you want to remove or replace. can then replace with a full stop (.) to make it easier as you have to replace with some text.



4. For example you can copy some of the formatting characters from the Notes which you want to remove and replace them with a full stop (.) so that it makes the Notes easier to read. 


Please see the screenshot example below: 



5. You can then click on 'Replace All' so that the formatting you have found is replaced with a full stop (.) as shown in the example below which makes the notes much easier to read.