- Joined
- Feb 2, 2020
- Messages
- 2
- Reaction score
- 0
- Points
- 1
Hello, this is my first post so please bear with me.
I am developing a simple Excel spreadsheet (Office 2011) and have mastered how to send emails.
The issue i have is, how do I input a line break in the body text?
I have tried %0A, %0D, =CHAR(13) but none of it works.
The body text is in a cell (wrapped text) saying, "Please contact your consultant as soon as possible. You will need to call 123456 to make an appointment. Ensure you bring your most recent prescription. Regards. Dr NO"
This all comes out in one line. I'd like to insert carriage returns (or new line) after each period (full stop).
I am losing what little hair I have on this.
Nelly
I am developing a simple Excel spreadsheet (Office 2011) and have mastered how to send emails.
The issue i have is, how do I input a line break in the body text?
I have tried %0A, %0D, =CHAR(13) but none of it works.
The body text is in a cell (wrapped text) saying, "Please contact your consultant as soon as possible. You will need to call 123456 to make an appointment. Ensure you bring your most recent prescription. Regards. Dr NO"
This all comes out in one line. I'd like to insert carriage returns (or new line) after each period (full stop).
I am losing what little hair I have on this.
Nelly