View Single Post
  #1   Report Post  
Posted to microsoft.public.word.formatting.longdocs
Russ Cook[_2_] Russ Cook[_2_] is offline
external usenet poster
 
Posts: 2
Default Deleting spaces at end of line/paragraph

Hi All,
New to the forum, just signed up because I have a glitch with Word that has
completely puzzled me.

I have produced a list of file names that are held in a folder (using
right-drag, paste as hyperlink into Word doc). I then used "find and replace"
to delete all of the unwanted file path info and to just leave the file name.

I plan to use what is left in an Excel Spreadsheet as source data for a
VLOOKUP to see whether the file exists, but have found that the list in Word
has a "Space" at the end of every line and each line is treated as a
paragraph.

The problem comes when I paste this list into Excel and it treats the
"Space" as a character and therefore my VLOOKUP fails.

So, is there an easy way to delete all of the additional spaces at the end
of each line (approx 3500 lines of file-names)?

Assitance is very much appreciated.