format excel text column to word paragraph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column (300 rows) of excel text

big sur below market,
california below market,
carmel below market,
carmel by the sea below market,
carmel valley below market,
carmel-by-the-sea below market,
casatroville below market,
Del Ray Oaks below market,
etc
I wan to take this row and format it in word as a paragraph, thus:
big sur below market, california below market, carmel below market, carmel
by the sea below market, carmel valley below market, carmel-by-the-sea below
market,
casatroville below market, Del Ray Oaks below market,

how?

etc
 
I got the paste special but, but I needs step by step for the find and
repalce part

JoAnn Paules said:
Copy and paste (Paste Special) the rows in as text. Find and replace the
paragraph marks with a comma and a space.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




sierralightfoot said:
I have a column (300 rows) of excel text

big sur below market,
california below market,
carmel below market,
carmel by the sea below market,
carmel valley below market,
carmel-by-the-sea below market,
casatroville below market,
Del Ray Oaks below market,
etc
I wan to take this row and format it in word as a paragraph, thus:
big sur below market, california below market, carmel below market, carmel
by the sea below market, carmel valley below market, carmel-by-the-sea
below
market,
casatroville below market, Del Ray Oaks below market,

how?

etc
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i get excel graphs, jpg's inserted in Word 2007 to fit mar 1
Copy Paste a value down a column with autofilter on 2
Excel Chart Customization 1
Turn columns off to insert a paragraph after them 2
how to count events w/in a timeframe? 8
Export Mail messages content to Excel 1
Export outlook mail message to excel 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top