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.

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" wrote:

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 - Genius ! That's exactly the trick....and far more simple than I
realised.
Huge thanks!

"DeanH" wrote:

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" wrote:

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.

You are most welcome.
DeanH

"Russ Cook" wrote:

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

"DeanH" wrote:

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" wrote:

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.

Originally Posted by DeanH

You are most welcome.
DeanH

"Russ Cook" wrote:

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

"DeanH" wrote:

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" wrote:

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.

Oops, you posted twice Russ, and I just discovered after I answered. See my reply there - if you r still interested. Dean's answer is ok from a Word pov, but I think doing it in Excel allows you to build it in. And if your file name has spaces in them, these spaces will also be replaced by Dean's Ctrl-H. (Sorry Dean, it's not my intention to push you down)