Text entry help

[[email protected]]

I have two columns of names (his & hers) and I would like to establish
a column with both names connected by "&". I have accomplished this but
would like to have just his name if there is no her.

Here is my current formula C2&" & "&E2

How can I eliminate the "7" and "E2 if there is a blank in E2

Thanks

[johncassell]

=IF(B1="",A1,A1&" & "&B1)

if cell a1 = john and b2 = sue then it will show john & sue but if only john is there then it will just show john

regards

John

[Elkar]

Try this:

=IF(C2<>"",C2,"")&IF(AND(C2<>"",E2<>"")," & ","")&IF(E2<>"",E2,"")

HTH,
Elkar

"[email protected]" wrote:

> I have two columns of names (his & hers) and I would like to establish
> a column with both names connected by "&". I have accomplished this but
> would like to have just his name if there is no her.
>
> Here is my current formula C2&" & "&E2
>
> How can I eliminate the "7" and "E2 if there is a blank in E2
>
> Thanks
>
>

[Dave Peterson]

Another option:
=c2&if(e2="",""," & " & e2)

If you really are putting blanks (space characters) in E2, then you may want to
stop--it's a bad habit for most things.

but if you do...
=c2&if(trim(e2)="",""," & " & e2)



[email protected] wrote:
>
> I have two columns of names (his & hers) and I would like to establish
> a column with both names connected by "&". I have accomplished this but
> would like to have just his name if there is no her.
>
> Here is my current formula C2&" & "&E2
>
> How can I eliminate the "7" and "E2 if there is a blank in E2
>
> Thanks

--

Dave Peterson

[[email protected]]

These solutions all worked and I thank you all.