Inserting the text value of a cell into a text cell in Excel

Bill Golden
Bill Golden used Ask the Experts™
on
A1 May or may not contain a text string.

If A1 contains a text string, say John Smith, A2 should read...

Schedule for John Smith

If A1 does not contain a text string, A2 should read...

You must enter a name in A1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

pls try

=IF(A1<>"","Schedule for "&A1,"You must enter a name in A1")

Open in new window

Regards
Bill GoldenExecutive Managing Member

Author

Commented:
Worked.  Thanks.
Bill GoldenExecutive Managing Member

Author

Commented:
Worked

Thanks,

Bill

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial