How to Join the several cell by using IF or Concatenate

[basavarajkh]

Hi


How do I -Join the Cell A1 B1 & C1, When B1 is #N/A & B2 is Blank

how to apply the formula, by using if or concatenate or some others formula.


A B C D

1 Jagdamba #N/A Services =?

2 Jagdamba Services =?


Plz send me Answer.


Regards

Basavaraj K H

basavarajkh@ibibo.com

 

[Guest]

Hi,


Do you mean:


=A1&iferror(B1,B2)&C1


Hope that helps?


M

 

[basavarajkh]

Sorry I did'nt get the answer.


My clint condition is like below


Jagadamba is in A1 Cell

#N/A is in B1 Cell

Service is in C1 Cell


I want write formula in D1 cell


& 2nd Question is

Jagadamba is in A2 Cell

is in B2 Cell (blank Cell)

Service is in C2 Cell


1st Questions: how to combain A1 B1 & C1 in the D1 if one of the cell have #N/A


&


2nd Questions: how to combain A2 B2 & C2 in the D2 if one of the cell have " " (blanks).


Plz help me to write formula in D1 & D2 cells.


Thanks & Regards


Basavaraj K H

Member of chandoo.org

 

[vijaySharma]

Ans 1: for Cell D1

[pre]

=A2&if(isna(b2),"",b2)&c2
Ans 2: for cell D2

=Trim(A2) & Trim(B2) & Trim(C2)

[/pre]
If your objective for Question 2 was only to get rid of that extra space.


~VijaySharma