Relative Content

Tag Archive for excelvbatextformattingmacros

Wondering if there is a way to auto format pasted text entered into a cell to 1) delete paragraph spaces, and 2 ) to limit characters per line

Wondering if there is a way to auto format pasted text entered into a cell in excel to 1) delete paragraph spaces, and 2) to limit characters per line via wrap after a certain number of characters. I typically try to self-service these things based on either formulas or vba found on helpful sites such as this, but I’m drawing a blank here. My task, essentially is copy/pasting emails in the a processing system, I created a template to highlight and auto-copy the text, but in order to format the email to fit within the system parameters I’m using notepad to manually format.