Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #18  
Old 08-26-2014, 10:13 AM
ryanjohnsond@gmail.com ryanjohnsond@gmail.com is offline Run Script to remove carriage returns on certain columns Windows 8 Run Script to remove carriage returns on certain columns Office 2007
Novice
Run Script to remove carriage returns on certain columns
 
Join Date: Aug 2014
Posts: 18
ryanjohnsond@gmail.com is on a distinguished road
Default

Quote:
Originally Posted by excelledsoftware View Post
...so is it just going to be columns C and D then? or does that differ for each workbook.
Yes. Always C and D. BUT! The row the headers "Items" and "No." starts on is not always Row 9. Sometimes the row number is at 42 or 36 or 17, but only a few instances I have seen this.

Quote:
Originally Posted by excelledsoftware View Post
So just to clarify are the carriage returns just in columns C and D or are they all over?
They are all over, but the Database Admin only needs me to remove the carriage returns on vertically spaced numbers in columns with header names, "Items" and "No." He needs them to be separated by commas: "1,2" "2,4,6".

Quote:
Originally Posted by excelledsoftware View Post
Thanks for your patience so far. I know you will be happy with the result.
No no... the thanks are all on my side. Thanks again, excelledsoftware!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Run Script to remove carriage returns on certain columns stop carriage return or enter key in a table Alaska1 Word 1 01-14-2013 08:48 AM
Run Script to remove carriage returns on certain columns Coding into a macro a carriage return sinbad Word VBA 6 02-27-2012 03:51 AM
Run Script to remove carriage returns on certain columns Paragraph (carriage) return font size revrossreddick Word 2 12-28-2011 01:33 PM
Carriage Return Help UCHelp Word 1 04-04-2010 10:11 PM
Run Script to remove carriage returns on certain columns Table of contents, remove spacing and put in 2 columns - need help urgently! nam085 Word 1 03-04-2010 08:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft