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

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.

.

Relevant Pages

  • Re: Controlsource wont let Dlookup to enter
    ... MOST US systems/computers default to a comma and I believe many other countries default to a semi-colon. ... Frustrated from entering the expression manually, using the syntax suggested in all the books and websources, I entered the builder of the ControlSource and clicked the Dlookup function from the list of functions. ... You might have to rebuild the form or you might need to decompile your database. ...
    (microsoft.public.access.gettingstarted)
  • Re: Controlsource wont let Dlookup to enter
    ... specify a comma or a semi-colon. ... Frustrated from entering the expression manually, using the syntax suggested ... ControlSource and clicked the Dlookup function from the list of functions. ... Is this happening in all controls on all forms in this database? ...
    (microsoft.public.access.gettingstarted)
  • Re: Saving Form Data Only as Plain Text File for Importing into Database
    ... The data is saved in comma ... separated value format so that it can be imported into a database. ... Doug Robbins - Word MVP ...
    (microsoft.public.word.vba.userforms)
  • Re: Automating repetitive tasks-creating text strings from excel i
    ... When using wildcards, you have to use ^13 instead. ... You would need to remove the final comma at the end of the last number, ... single row with commas seperating the unigue number. ... I need the text string to look like this so I can copy and paste it ...
    (microsoft.public.word.docmanagement)
  • Re: Controlsource wont let Dlookup to enter
    ... if it's OK to have comma as default standard for List Elements ... Frustrated from entering the expression manually, using the syntax suggested ... ControlSource and clicked the Dlookup function from the list of functions. ... Is this happening in all controls on all forms in this database? ...
    (microsoft.public.access.gettingstarted)