Results 1 to 3 of 3

Data Validation Abbreviation

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2020
    Location
    Texas
    MS-Off Ver
    Surface
    Posts
    1

    Data Validation Abbreviation

    Newbie here.

    I'm trying to create a drop down list, tied to an image location on my computer.

    I've successfully created a drop down list with a path to the image (C:\Users\username\Documents\PRESENTATION\LINKS), but when I click the drop down menu, the path is too long to see what the user will be selecting.

    See attached "test" file for example -

    the dropdown list reads -
    'C:\Users\username\Documents\PRESENTATION\LINKS\image-1.jpg
    'C:\Users\username\Documents\PRESENTATION\LINKS\image-2.jpg

    when what I want to show is just -
    'image-1
    'image-2



    Is this possible? Any help would be appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Abbreviation of an IF formula
    By sirdon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2017, 05:17 AM
  2. Replies: 0
    Last Post: 11-07-2014, 12:44 PM
  3. [SOLVED] Macro to lookup data text and replace it with abbreviation.
    By james1432 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-20-2013, 05:56 AM
  4. One-Letter Abbreviation for Weekday
    By harrisjd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2009, 02:50 PM
  5. month abbreviation using TODAY()
    By farrell in forum Excel General
    Replies: 8
    Last Post: 12-05-2008, 02:34 PM
  6. Abbreviation conversion
    By borchesz121 in forum Excel General
    Replies: 3
    Last Post: 07-07-2005, 05:12 PM
  7. spell out state name from an abbreviation
    By julieb in forum Excel General
    Replies: 2
    Last Post: 05-19-2005, 01:06 PM

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