concatenate #N/A
If that's the case you may wish to suppress the #N/A errors or force them to
return a text N/A value.
The problem you were running into resulted from the fact that #N/A is a
logical operator not a text value.
Dave
--
Brevity is the soul of wit.
"Bry" wrote:
Thanks Dave,
that worked - probably a good time to mention om concatenating 30 cells, 28
of which could possible have "#N/A" as a result.
This is going to be one very long formula.
cheers for your help
Bry
"Dave F" wrote:
OK, try this: =CONCATENATE(A1,B1,IF(ISERROR(C1),"#N/A",C1))
Dave
--
Brevity is the soul of wit.
"Bry" wrote:
Hi Dave, thanks for your reply
The only formula that i have a problem with is the concatenate one. i will
try and example.
my command =CONCATENATE(A1,B1,C1)
A1 = "15"
B1 = "SAUSAGES"
C1 = "INAPAN"
this results 15SAUSAGESINAPAN
A1 = "15"
B1 = "SAUSAGES"
C1 = "#N/A"
this results #N/A
what i am trying to achieve is the result 15SAUSAGES#N/A
I hope this makes more sense,
thanks
Bry
"Dave F" wrote:
What errors are you seeing? Post the specific formula you are using and any
errors which are returned.
Dave
--
Brevity is the soul of wit.
"Bry" wrote:
Hi
I have a problem concatenating cells, all are formated as text but some have
been taken from another worksheet where the cells have come back with a #N/A
result, in instances where this happened then the concatenate also errors.
What im looking for is a way of concatenating everything that is in the
cells selected even if its a '#N/A' error.
|