LinkBack URL
About LinkBacks
ensmith 
I am looking for a concatenate formula that "will not" include a blank cell and only concatenate cells with text only. See attachment for example thanks.
I am looking for a concatenate formula that "will not" include a blank cell and only concatenate cells with text only. See attachment for example thanks.
In F2, then drag down
=IF(AND(ISTEXT(TRIM($D2)),TRIM($D2)<>"",ISTEXT(TRIM($E2)),TRIM($E2)<>""),D2&E2,"")
Thanks for the formula, however is it possible to revise the formula to enable the name in column D to be reflect in column F and only the names in column E that are only adjacent to names in column D, i.e. if there is a name in cells D4&E4 or D4 concatenate with the reulst
In f2-
Copy down=IF(AND(TRIM(D2)<>"",ISTEXT(TRIM(D2))),D2&IF(AND(TRIM(E2)<>"",ISTEXT(TRIM(E2))),E2,""),"")
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks