Would anyone know how to return only the first several digits of a vlookup value? I'm trying to save space by shrinking the columns and only having a portion of the lookup value.
For example, my source data shows the table below. I would like to just pull in "Jones, Indiana". I've tried variations of LEN and TRIM nested with the VLOOKUP, but can't seem to get it right. Thanks for any ideas!
<tbody>
</tbody>
For example, my source data shows the table below. I would like to just pull in "Jones, Indiana". I've tried variations of LEN and TRIM nested with the VLOOKUP, but can't seem to get it right. Thanks for any ideas!
Employee ID | Employee Name |
123456 | Jones, Indiana Junior the Fourth Esquire |
<tbody>
</tbody>