If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Deleting spaces at end of line/paragraph
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. |
#3
|
|||
|
|||
Deleting spaces at end of line/paragraph
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. |
#4
|
|||
|
|||
Deleting spaces at end of line/paragraph
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. |
#5
|
|||
|
|||
Quote:
__________________
Henk van Ekelenburg co-author of the eBook "Mastering Microsoft Word for Scientific Reports" (and other long documents) www.masteringword.eu/?Off |
Thread Tools | |
Display Modes | |
|
|