Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
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
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Deleting spaces at end of line
Russ Cook;2539668 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. I am not sure if I understand all your fiddling, but .... If you are sure that none of the file names have spaces included you can replace these spaces by nothing. However, it's probably easiest to "repair" the names in Excel, using text functions (e.g. TRIM, that removes all trailing spaces if existing). You can nest them with VLOOKUP, or, as I prefer because it is easier to see what you'r doing and to trouble-shoot if needed, first cleanup yr file name list. HTH -- Henk57 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting spaces on labels when nothing is in a field | Mailmerge | |||
line spaces in WORD | Microsoft Word Help | |||
add spaces with line numbers | Microsoft Word Help | |||
Deleting extra line spaces | Microsoft Word Help | |||
two spaces break at end of line | Microsoft Word Help |