Re: Automating repetitive tasks-creating text strings from excel i

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Herb,
When I inserted the paragragh symbol, word responded that ^p was not a
valid special character in the find what box. I tried go to the menu bar and
using the insert special character, but the paragrapgh symbol that looks more
like a music note would not insert into the find box.

And yes, you are understanding that I end up with pages of rows of numbers
that need to be placed into a single test string with a comma in between each
unigue number.

Thanks again,

Jacky D.

"Herb Tyson [MVP]" wrote:

If I'm understanding you correctly, you end up with a series of numbers on
separate lines in Word. This series could be many pages of numbers--not just
the four shown in your example.

You should be able to convert the list of numbers into a single row of
numbers quite easily using find/replace. Press Ctrl+H:

Find what:^p (special symbol for paragraph mark)

Replace with:,

Replace All.

You would need to remove the final comma at the end of the last number, or
just not select it when you copy to the clipboard for pasting into the
database search box.

You can even turn Paste Special Unformatted into a single keystroke, if you
like. Details here:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=128

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Jacky D." <Jacky D.@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:22369589-5E0E-42EA-8790-A31518E98E90@xxxxxxxxxxxxxxxx
Every day, I create a list of unique numbers from excel, then copy and
paste
into word using paste special- unformatted text since I do not want the
cells
to be included. I take this column of unigue numbers and manually go into
it,
placing a comma at the end of the text, then use delete to get the text in
to
single row with commas seperating the unigue number. For example, I start
with rows that look like this:
1234
2345
3456
4567
and turn it into this:
1234,2345,3456,4567

I need the text string to look like this so I can copy and paste it into a
database to search for these numbers. Is there any other way to paste this
information from excel into word so I can do away with all these repetitve
keystrokes, or can someone help me "loop" the keystrokes in a macro so I
can
easily get the text strings I need? On occasion, the list when copied into
word will be 10+ pages, a huge time waster, but still easier than
keystoking
each unique number into the database to search. I am using word and excel
2002 accoring to the "about" tab in the software.

Thank You,
Jacky D.


.