CODEWITHSUNDEEP
excel
user4760532
user4760532

Reputation:

How to use multiple columns for texts in Excel

I have multiple columns as follows

A	B	C	D	Outcome
			Y	Y
	N			N
				
N				N
Y				Y

My outcome is in the column E. If the cell is filled, I want to see it in the outcome column. If not I want to see a blank cell. I tried my best, but I could do it. Is there a simple function to do it. Thanks for your help.

Upvotes: 0

Views: 37

Answers (2)

pnuts
pnuts

Reputation: 59485

Try :

=A2&B2&C2&D2

Upvotes: 1

James Hawkins
James Hawkins

Reputation: 218

There are a number of ways to accomplish this. One would be:

// Copy this down 
In Cell E2: =IF(COUNTA(A2:D2)=0,"",CONCATENATE(A2,B2,C2,D2))

Upvotes: 1

Related Questions