skip to main content

Calling all Microsoft Excel Experts!

13 years ago

I have an excel document with peoples' names in each cell down Column A. I have to copy and paste this list into Microsoft Word, but I don't want them to be in cells. Is there a way to make the cells disappear so I don't have to type hundreds of names to make a list in my Word doc?

Thank you for any help!

Sort by:Oldest

Comments (4)

owbist
13 years ago
Open XL and Word. In XL click and hold the left mouse button down on the first needed name in column A, drag down to highlight all those needed and release the mouse.

Right click anywhere on the highlighted list and click Copy. Bring up Word and have the cursor where you want the list to start if other than the top left corner, right click and click Paste. Done.

This is with Office 2007, if it does not work for you be sure to include the version you are using.
judys_ont
13 years ago
If you dont want your Word list to be in cells:
do your copy and paste into Word. Select the cells in Word and go to table>convert>table to text. You can separate with paragraph marks to get a list but without it being a table.
(This is using Word 2003)
hth-Judy
Related Discussions
Calling all tea experts
Q
Comments (42)
'Susan Louise' is one heck of a rose. Can be grown as a climber or as a self supporting bush, very attractive when the lower laterals are removed and the bush is tree shaped and sized. I am madly in love with this rose for its huge pink and cream blossoms that bloom in all 4 seasons here, when most Tea roses reduce bloom production, or stop blooming, in winter. 'Devoniensis' traditionally called the Magnolia Rose, shows the most exaggerated style of bloom I've ever seen in a rose that is cup shaped, and filled with petals inside that are arranged in scalloped rows. It makes me want to dive into the rose blossom, like Alice going down the rabbit hole. 'Anna Olivier' is the most deeply fragrant Tea I've ever smelled, I would guess that might come from Bourbon influence. A wonderful rose. Of all white Tea roses I love our white 'Maman Cochet' the best. In winter the pink guard petals turn white too, making this starry Tea rose a snow beauty of a rose. 'General Tartas' I like him fine. If Tea roses were the only roses I could grow, I would remain content. Luxrosa
...See More
Calling All Experts
Q
Comments (15)
I applied corn meal last weekend (Washington's (real) Birthday). My normal schedule is pretty easy to remember: Washington's Birthday Memorial Day 4th of July Labor Day Thanksgiving Note that I'm pretty far south like the OP. The reason I apply on Washington's Birthday is that happens to be 3 weeks prior to our normal 'last frost' date. There are lawns already being mowed in my neighborhood, so early spring is here. If I lived more north, I would go by the 'last frost' date or find some trees that flower out early. Nature usually provides the best signals for when to do things. I go by a tree down the street from me. When it is fully leafed out is the time to fertilize for me.
...See More
Calling all tiling experts: Hydroban or HPG?
Q
Comments (27)
You will get aprox 50 Square per gallon of Hydro ban if you apply it over Green EBoard or cement Board on the rough side. You will get closer to 60 Square feet of coverage over the smooth side of Green EBoard. Can you measure out the exact square footage and what you plan for a shower base and the walls. The Kerdi Drain is an excellent product but a bit on the pricey side at $130.00 Nobel makes a sweet little adapater piece for a regular drain $12.00 that can give you a liquid tie in point. Contact Laticrete for approval - I spoke just two days back to Eric at Nobel head office and he told me about this greta Nobel product. I have some of those en route as well. Eric is a great guy - email him and he can tell you all about it. I wish he chimed in here from time to time... Eric? Where are you? sales@noblecompany.com JW Here is a link that might be useful: Nobel products for your bathroom renovation
...See More
Calling all terrazzo experts!
Q
Comments (2)
You need to be real careful here. Use a different grit on part of the floor than what was used on the rest of the floor, and it'll show up as an either shiny or dull spot in relation to the rest. You'[re talking about starting with 100 grit and working up to 1300. Most floors FINISH at between 100 and 150 grit. Use 1300, and walking across that floor will be like ice skating! I know it's going to cost you, and you're going to have to wait. But it'll be money well spent and worth the wait. Refinishing terrazzo is not a DIY task. If all you were going to do was strip and reseal, that's a different story. In that case, you don't even need a sander. But from the sound of it, that's not what's needed here.
...See More
bpgreen
13 years ago
Something I've done to get rid of ALL formatting is to paste into Notepad first, then select all, copy and paste into Word. It's a few extra steps, but it ensures that all extra formatting is gone.
sameboat
Original Author
13 years ago
Thank you everyone. I ended up figuring it out. I copied the column, then in my Word doc clicked on "Paste Special" and then "unformatted text" - worked perfectly!

Related Stories

FARM YOUR YARD How to Grow Vegetables in Containers

By Annie Thornton

Get glorious vegetables and fruits on your patio with a pro’s guidance — including his personal recipe for potting mix

DECORATING GUIDES Expert Talk: Designers Open Up About Closet Doors

By Lawrence Karol

Closet doors are often an afterthought, but these pros show how they can enrich a home's interior design

HEALTHY HOME How to Childproof Your Home: Expert Advice

By Becky Dietrich, Interior Designer

Safety strategies, Part 1: Get the lowdown from the pros on which areas of the home need locks, lids, gates and more

TASTEMAKERS Ask an Expert: What Is the One Design Rule You Live By?

By Luisa Rollenhagen

Eight home experts share their top design rules

COLOR Paint-Picking Help and Secrets From a Color Expert

By Tiffany Carboni

Advice for wall and trim colors, what to always do before committing and the one paint feature you should completely ignore

BATHROOM DESIGN Expert Talk: Frameless Showers Get Show of Support

By Lawrence Karol

Professional designers explain how frameless shower doors boosted the look or function of 12 bathrooms

MY HOUZZ Houzz Call: Looking for Writer/Photographers!

Love to photograph homes and write about interior design? You could be our next great contributor

ARCHITECTURE All the Possibilities: 4 Homes at the Edge of the Earth

By Eric Reinholdt, Architect

Travel to the far reaches of land, where these residences straddle rocky cliffs, leafy lakeshores and choppy inlets

GREEN BUILDING What's LEED All About, Anyway?

By Mariana Pickering (Emu Building Science)

If you're looking for a sustainable, energy-efficient home, look into LEED certification. Learn about the program and its rating system here

GARDENING GUIDES New Ways to Think About All That Mulch in the Garden

By Benjamin Vogt / Monarch Gardens

Before you go making a mountain out of a mulch hill, learn the facts about what your plants and soil really want

Sponsored

More Discussions

Can I stop my modem from gathering and sharing our data?

12

sound missing on Dell

3

Problems with Outlook 2013

0

Upgrading Windows 11 from Home to Pro

2

Any suggestions for a very secure non-web-based email?

3