|
Inline Carriage Return?
How do I insert a CrLf into a formula?
I currently have: =IF(Requestor!E41="YES", "Project Management to be performed by " & Requestor!G41 & ". Scope: " & Requestor!M41,"") What I want to do, is insert a carriage right before the word "Scope" but Excel does not seem to recognize VBCrLf - Is there a way to do this? Thank you in advance. |
Inline Carriage Return?
Rusty,
Format the cell for wrapping, and use the formula =IF(Requestor!E41="YES", "Project Management to be performed by " & Requestor!G41 & "." & CHAR(10) & "Scope: " & Requestor!M41,"") HTH, Bernie MS Excel MVP "RustyR" wrote in message ... How do I insert a CrLf into a formula? I currently have: =IF(Requestor!E41="YES", "Project Management to be performed by " & Requestor!G41 & ". Scope: " & Requestor!M41,"") What I want to do, is insert a carriage right before the word "Scope" but Excel does not seem to recognize VBCrLf - Is there a way to do this? Thank you in advance. |
| All times are GMT +1. The time now is 08:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com