 |
 | 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 / Excel / New Users / March 2008What is the best way to program the custom cell format
I need to have a format of all the cells of selected row to be 8 characters and if the word of the cell is less than 8 characters, then padding with space. For example, if I enter "ABC" in one of the cells of the row, then the format will automatically become "ABC ", which 5 spaces automatically appended to "ABC". Here is a formula, not a format =A1&REPT(" ",8-LEN(A1)) best wishes  SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email >I need to have a format of all the cells of selected row to be 8 > characters and if the word of the cell is less than 8 characters, > then > padding with space. For example, if I enter "ABC" in one of the cells > of the row, then the format will automatically become "ABC ", > which 5 spaces automatically appended to "ABC". You can use custom format in cell like @" " then the entry is allways FORMATED (as You requested) with 5 spaces after But You never "see" them 5 spaces without aligning cells to right Henn >I need to have a format of all the cells of selected row to be 8 > characters and if the word of the cell is less than 8 characters, > then > padding with space. For example, if I enter "ABC" in one of the cells > of the row, then the format will automatically become "ABC ", > which 5 spaces automatically appended to "ABC".
|
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.