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
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
|
|||
|
|||
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 | |
|
|