Deleting spaces at end of line/paragraph

[Russ Cook]

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.

 

[DeanH]

Use Find/Replace (Ctrl+H), Find for "[space]^p" that is Spacebar followed by
Shift+6 followed by lowercase p.
Replace with ^p
The ^p is the code for the paragraph marks.
Repeat this until you get 0 changes.
Hope this helps
DeanH

 

[Russ Cook]

DeanH - Genius ! That's exactly the trick....and far more simple than I
realised.
Huge thanks!

Use Find/Replace (Ctrl+H), Find for "[space]^p" that is Spacebar followed by
Shift+6 followed by lowercase p.
Replace with ^p
The ^p is the code for the paragraph marks.
Repeat this until you get 0 changes.
Hope this helps
DeanH

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.

 

[DeanH]

You are most welcome.
DeanH

DeanH - Genius ! That's exactly the trick....and far more simple than I
realised.
Huge thanks!

Use Find/Replace (Ctrl+H), Find for "[space]^p" that is Spacebar followed by
Shift+6 followed by lowercase p.
Replace with ^p
The ^p is the code for the paragraph marks.
Repeat this until you get 0 changes.
Hope this helps
DeanH

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.