Indirect and Concatenate to return Names

[tbrogdon]

I had another post which was very gratefully answered concerning the
use of INDIRECT to return a list of employees who work on a user-
chosen shift in the form of a list box.

Now I am wondering if the employees names are broken up into FirstName
and LastName, how can I return a list of full names (e.g., John
Brown, Erin Carr, etc.) in the form of another list box for the user
to make another choice?

I suspect I will have to use my newly acquired INDIRECT with a
CONCATENATE but I am unsure about the structure.

Am I on the right track?

Thanks,

Tim

 

[Guest]

Without knowing the history of this request, I can only assist with the
Concatenate part.

Let's say the first name is in A1 and the last name is in B1, to get the
First and Last name, enter this

=A1 & " " & B1

 

[Bob Phillips]

=INDIRECT(formula to get first name)&" "&INDIRECT(formula to get last name)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[tbrogdon]

Thanks a bunch!

Tim