smithjake23
New Member
- Joined
- Aug 29, 2011
- Messages
- 1
I have cells P2, Q2, R2, S2, T2, and U2 that contain a formula that returns the header text from columns J, K, L, M, N, and O, respectively, when the condition "Yes" is true. An example of the formula used in P2 is as follows:
=IF(J2="YES",J1,"")
I would like to do the following in V2
(1) concatenate the text results from cells P2, Q2, R2, S2, T2, and U2
(2) Insert a carriage return between each of the returned text strings, and
(3) only concatenate the cells where text exists (i.e. will not have carriage returns from empty cells.
Is there a formula that can do this?
Thanks
Jake
=IF(J2="YES",J1,"")
I would like to do the following in V2
(1) concatenate the text results from cells P2, Q2, R2, S2, T2, and U2
(2) Insert a carriage return between each of the returned text strings, and
(3) only concatenate the cells where text exists (i.e. will not have carriage returns from empty cells.
Is there a formula that can do this?
Thanks
Jake