Re: how do i combine three columns in excel.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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
.



Relevant Pages

  • Re: [PHP] looping through a $_POST variable
    ... looks like that is my problem it is not separating the emails ... I will validate the emails after I get the loop to work ... $memberid comes from a part of the script I did not show you ... escape the data you embedded into the SQL, but I don't see how you ...
    (php.general)
  • Re: sent box - show sent to
    ... possible to have my 'Committee file',, list the ... Without separating them? ... The emails 'from' me, I move from Outlook's 'Sent' folder to my own one. ...
    (microsoft.public.outlook.general)
  • Separate email accounts suddenly joined - help!
    ... FYI, when I turn on my old computer, outlook express works just fine and is separating my emails as it should, why won't the new version work? ... How do I fix these problems? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Need suggestionf for what program to use
    ... Review "Shared Workbook" in Excel Help. ... want to share a file that is in Excel format right now. ... We want this to be a 'living" document, in the sense that any one of us can change the information, such as dates, and replies to emails we track in this document for production info. what would be best approach to do this and not have to buy any hardware, if possible. ...
    (microsoft.public.office.misc)