| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Carriage return | Excel Discussion (Misc queries) | |||
| Carriage Return | Excel Worksheet Functions | |||
| Squares for carriage return | Excel Worksheet Functions | |||
| VBA...How do you state a carriage return? | Excel Programming | |||
| Carriage Return | Excel Programming | |||
Linear Mode
