Results 1 to 17 of 17

Eliminate data entry key strokes and mistakes in a cell - Input mask? Textlike?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Boston
    MS-Off Ver
    MS 365
    Posts
    225

    Eliminate data entry key strokes and mistakes in a cell - Input mask? Textlike?

    I want to make data entry in a cell easier so the input person does not have to enter the two constants every single time.

    For instance, in column A1 the only entries will be a 9 characters length; ####AA###.

    The AA never changes and the other charters are numeric, fixed length 9 character total.

    Some commands researched are textlike and input mask. Input mask sounds best but in any case don't know how to use them.

    Would guess the textlike formula would be like this - but how to actually use it no idea
    "=TextLike(A1, "[0-9][0-9][0-9][0-9][A][A][0-9][0-9][0-9]")"

    I search our forum but no hits on textlike, although an input mask might be better.

    Thanks
    Last edited by JET2011; 01-31-2013 at 01:57 AM.

Thread Information

Users Browsing this Thread

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

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