When it enters into excel it creates random line breaks in to text:
I've blurred the actual text because it contained sensitive information but the cell on the top is where I've copied and pasted the text from the email manually and the one on the bottom was done using the formula above in power automate. I need it to stop adding those extra line breaks if possible. Any advice?
Thank youuartimin andtrice602. I appreciate the suggestions. Sad to report neither attempts at using the replace function have successfully stopped the extra line breaks. I'm sure that's the way to go, I probably just need different inputs.
If anyone has any other ideas I could try please let me know! I'll be happy to experiment until I get this.
If you use "Convert HTML to Text" to remove the HTML tags, sometimes it will break it into several lines. It is difficult to remove HTML tags while keeping the original text format.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.