Re: Names & Addresses

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

From: Peo Sjoblom (terre08_at_mvp.org)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 08:21:41 -0400

Copy, select a new sheet and do edit>paste special and check transpose 

-- 
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.
Regards,
Peo Sjoblom
"Samantha" <anonymous@discussions.microsoft.com> wrote in message
news:1d7b701c45464$a5253b80$a301280a@phx.gbl...
> Hi
>
> I have a list of names and addresses which are all listed
> in column on vertically but I need to change it to
> horizontally without having to retype all the names in
> again. Is this possible as I want to do a mailmerge and I
> can't this way Unless someone knows a way around it?
>
>
>
> Thanks heaps
>
> Samantha

Relevant Pages

  • Re: unusual characters
    ... to be typed on the numpad in your earlier message. ... >> No private emails please, ... >> benefit keep the discussion in the newsgroup. ... >> Peo Sjoblom ...
    (microsoft.public.excel.misc)
  • Re: Return value of "YES" when range contains one cell that has data
    ... No private emails please, for everyone's ... benefit keep the discussion in the newsgroup. ... Peo Sjoblom ... "Beth Dye" wrote in message ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Count based on date
    ... "Peo Sjoblom" wrote in message ... > No private emails please, ... > benefit keep the discussion in the newsgroup. ... > "Amy" wrote in message ...
    (microsoft.public.excel.worksheet.functions)
  • Re: removing hypens to make phone No. for another program
    ... misunderstanding. ... No private emails please, for everyone's ... benefit keep the discussion in the newsgroup. ... Peo Sjoblom ...
    (microsoft.public.excel.misc)
  • Re: Math with Dates?
    ... No private emails please, for everyone's ... benefit keep the discussion in the newsgroup. ... Peo Sjoblom ... > Possibly a second column that can do a function to do that to get the ...
    (microsoft.public.excel.misc)