Hello,
I have a validation list from a named range that is used for multiple purposes. Some of the cells have limited space and the 1st word from each of the choices on the list would suffice in that case. Is there a way to make a selection and only have the 1st word or just a certain number of letters populate the cell?
I would suggest creating a new range of data based on that 1st range, and then use something like...
=left(A1,search(" ",A1,1)-1)
or
=left(A1,5) 5 being the number of characters that you want to use - this can be hard-coded into the formula, or put in another cell and then referenced.
You can then create another name for this new range, andthen use that in the DV
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks