Form Dropdown Combo Box

H

HRIS

My dropdown combo box currently displays one column. What I would lik
to do is have the box dispay column A and B but only extract the I
from B. How would I be able to do this
 
A

Andrew

I'm not sure if I understand the problem correctly, but have you trie
using a CONCATENATE function to join the values in Columns A & B?

Say you have first names in Column A and surnames in Column B. Us
something like =CONCATENATE(A1," ",B1) in Column C for the dropdow
list. You could also use =A1&" "&B1. The apostrophe marks are just t
open a space between A1 and B1.

Hope this helps
 
Top