Re: how do i combine three columns in excel.
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Sat, 24 Sep 2005 13:33:32 -0500
Maybe just a formula like:
=a1&"@"&b1
dragged down would be enough.
excel help wrote:
>
> I separated a long list of emails using test to columns separating them using
> the @ separator. I have two columns now and have corrected the emails but
> there is no @ sign. I was going to put a column of @ signs but I still can't
> combine all the columns. I have over 2000 personal emails to combine.
> thanks
> bernie
--
Dave Peterson
.
- Prev by Date: Function To Convert Liters To Imperial Gallons & Vice Versa
- Next by Date: Re: Function To Convert Liters To Imperial Gallons & Vice Versa
- Previous by thread: Function To Convert Liters To Imperial Gallons & Vice Versa
- Next by thread: How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied?
- Index(es):
Relevant Pages
|