Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #21  
Old 08-27-2014, 11:52 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

I just noticed that there are some columns that are "1-3". Your current code turns those numbers into hash tags, ####. 1-3 means numbers 1 thru 3. I need to have those left as they are.

Interesting note: After I run the macro, when I click on the #### column, the Formula url shows the formatting of "1/3/2014" I don't know what's going on.

Open and run the macro (F8) "runing_code_will_change_to_hash-test2.xlsm"
Please see attached file, "problems_with_rows_4-6.xlsm"
Attached Images
File Type: png formatting_image.png (24.1 KB, 16 views)
Attached Files
File Type: xlsm problems_with_rows_4-6.xlsm (17.8 KB, 9 views)
File Type: xlsm runing_code_will_change_to_hash-test2.xlsm (24.3 KB, 9 views)
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