software

I need c1 to equal A1.B1. I know how to get C1=A1amp;B1 but I need a period
separating them. Then in D1 I need it to equal . Help
would be appreciated

C1: =A1amp;quot;,quot;amp;B1
D1: quot;

HTH
--
AP

quot;Aaron Danielsquot; gt; a écrit dans le
message de ...
gt; I need c1 to equal A1.B1. I know how to get C1=A1amp;B1 but I need a period
gt; separating them. Then in D1 I need it to equal . Help
gt; would be appreciated
Aaron,

You could try this:

In cell C1 type: =A1amp;quot;.quot;amp;B1

In cell D1 type: quot;

As far as enabling the hyperlink so that all you do is click. I don't know,
but you could do it via VBA.

You can create a forumula that will 'mailto' but that will only open a blank
email.

Hope this helps.quot;Aaron Danielsquot; wrote:

gt; I need c1 to equal A1.B1. I know how to get C1=A1amp;B1 but I need a period
gt; separating them. Then in D1 I need it to equal . Help
gt; would be appreciated