 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Long Documents / December 2007Deleting 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 > Hi All, > New to the forum, just signed up because I have a glitch with Word that has [quoted text clipped - 16 lines] > > Assitance is very much appreciated. 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. [quoted text clipped - 24 lines] > > > > Assitance is very much appreciated. You are most welcome. DeanH > DeanH - Genius ! That's exactly the trick....and far more simple than I > realised. [quoted text clipped - 28 lines] > > > > > > Assitance is very much appreciated. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.