I have two formulas whose results I want to join with the word 'and' if there is text in both cells. If there isn't text in both cells then and won't be required.
Formula at present: =C2&" and "&C11
How do I change it so that if there no text in one or both cells it won't show the word " and "
Ben
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Something like this?
=if(and(istext(c2),istext(c11)),C2&" and "&C11,"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
try..
=IF(OR(C2="",C11=""),C2&C11,C2&" and "&C11)
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you so much for helping out! Ace_XL you nailed it!Thank you to everyone who posted to help me!
Another way:
=C2&IF(COUNTA(C2,C11)>1," and ","")&C11
regards, LMP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks