+ Reply to Thread
Results 1 to 7 of 7

Custom cells (column) to enter and show specific length of characters

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Shahdol, India
    MS-Off Ver
    Excel 2007
    Posts
    18

    Custom cells (column) to enter and show specific length of characters

    I want to custom a column to enter 10 characters, if characters are less than 10 then custom setting will add spaces " " to complete count of characters. I know there is a way to custom numeric feilds, but how it can be done with text? Please help.
    text.jpg
    Last edited by roshanakhtar; 05-19-2015 at 02:31 AM.

  2. #2
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Custom cells (column) to enter and show specific length of characters

    this is a duplicate post roshan,,,pls don't do that...read the forum rules...

  3. #3
    Registered User
    Join Date
    02-10-2012
    Location
    Shahdol, India
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Custom cells (column) to enter and show specific length of characters

    Sorry for that, at first I posted it with excel file attachment, but due to slow internet speed I was unable to see the same, hence I edited my post with jpg attachment which caused the duplicate post. I will be carefull in future.

  4. #4
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Custom cells (column) to enter and show specific length of characters


  5. #5
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: Custom cells (column) to enter and show specific length of characters

    Ye duplicated posts are a bit of a shame, but I have had it myself. Can be kind of ennoying.

    Hope this helps
    Text_2.xlsm
    Inveniam Viam Aut Faciam

  6. #6
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Custom cells (column) to enter and show specific length of characters

    its k.....I am not sure the thing u needed is achived or not....but I think VBA will help u

  7. #7
    Registered User
    Join Date
    02-10-2012
    Location
    Shahdol, India
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Custom cells (column) to enter and show specific length of characters

    Thanx a lot Evolta, VBA worked fine as I needed. Many Thanx Jaya, for your help and advice.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-24-2015, 11:44 AM
  2. [SOLVED] Length of characters in a column to provide output as an error message
    By Christopherdj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2015, 12:59 AM
  3. Enter custom date range to show data
    By ericbsandiego in forum Excel General
    Replies: 4
    Last Post: 12-11-2008, 01:56 PM
  4. How do I format a specific column of cells to have a limit aount of characters?
    By limshady411 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2005, 02:35 AM
  5. [SOLVED] how to increase my column length to enter 600,000 entries
    By jeffrey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2005, 05:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1