merge cells with a twist

  • Thread starter Thread starter jd
  • Start date Start date
J

jd

A B C
joe @ domain.com

trying to merge cells in a row so that column a(joe) b(@) c(domain.com) and
that result is (e-mail address removed)
Thank you.
 
Thank you so much. That was perfect.
Is it too much to ask for a way to sort by domain.com or extract a specific
domain.com out?
abc.com
abc.com
abcd.com
abcde.com
abcde.com
abcdef.com
 
I had to use a formula like:

=HYPERLINK("mailto:"&A1&B1&C1)

to be able to start an email by clicking on that hyperlink.
 
Question is, is that what the OP wants?

--
Regards,

Peo Sjoblom

(No private emails please)
 
Excellent question, young man.

But most of my responses are for my own benefit anyway <vbg>.
 
Dave Peterson said:
Excellent question, young man.

But most of my responses are for my own benefit anyway <vbg>.
Click to expand...

Of course, all 110 000 (must be something like that by now), that goes
without saying <bg>


Peo
 
I think I tried that by selecting the entire workbook (to keep the columns
in sync) but it got sorted by column A.
How do I accomplish this and keep column A in sync with column C?
I am trying these things on my own before posting and appreciate the help.
 
I think I figured it out.
I took Column C and made it column A. Then when I selected the entire
workbook and did the sort... it was all good.
It's crude and not automated but it does work.
See, I am trying things.
Thank you all!
 
Back
Top