Posted to microsoft.public.excel.programming

RustyR

external usenet poster

Posts: 9

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Carriage return	CWH	Excel Discussion (Misc queries)	1	March 16th 10 01:54 PM
Carriage Return	Freddo	Excel Worksheet Functions	2	March 22nd 07 10:34 AM
Squares for carriage return	Helena	Excel Worksheet Functions	3	July 6th 05 09:21 PM
VBA...How do you state a carriage return?	woz999[_2_]	Excel Programming	4	April 28th 04 08:51 PM
Carriage Return	Tom Ogilvy	Excel Programming	3	August 20th 03 07:22 PM

All times are GMT +1. The time now is 04:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us