merge cells with a twist

J

jd

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
 
D

Dave Peterson

I had to use a formula like:

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

to be able to start an email by clicking on that hyperlink.
 
P

Peo Sjoblom

Question is, is that what the OP wants?

--
Regards,

Peo Sjoblom

(No private emails please)
 
D

Dave Peterson

Excellent question, young man.

But most of my responses are for my own benefit anyway <vbg>.
 
P

Peo Sjoblom

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
 
J

jd

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.
 
D

Dave Peterson

And close to 50% are correct (or on point!).



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

Peo
Click to expand...
 
J

jd

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!
 
Top