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
Anonymous
Unregistered
Posts: 8
Hi,
Do you mean:
=A1&iferror(B1,B2)&C1
Hope that helps?
M
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
Ans 1: for Cell D1
Subscribe
=A2&if(isna(b2),"",b2)&c2Ans 2: for cell D2
=Trim(A2) & Trim(B2) & Trim(C2)If your objective for Question 2 was only to get rid of that extra space.
~VijaySharma
You must log in to post.
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
