Inline Carriage Return?

  • Thread starter Thread starter RustyR
  • Start date Start date
R

RustyR

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit to IFs ??? 3
Split data around a carriage return 10
something more than vlookup?? 11
Carriage Return 7
What are the character codes of a carriage return entered in a comment? 5
Text String (Edit w/Carriage Return) 3
Problem reading text file 2
General approach/platform question 1

Back
Top