Indirect and Concatenate to return Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tbrogdon@gmail.com - 28 Oct 2007 21:22 GMT

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

Reply to this Message

Barb Reinhardt - 28 Oct 2007 22:07 GMT

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

Signature

HTH,
Barb Reinhardt

> 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-
[quoted text clipped - 13 lines]
>
> Tim

Reply to this Message

Bob Phillips - 28 Oct 2007 22:34 GMT

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

Signature

---
HTH

Bob

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

>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-
[quoted text clipped - 13 lines]
>
> Tim

Reply to this Message

tbrogdon@gmail.com - 29 Oct 2007 02:20 GMT

Thanks a bunch!

Tim

Reply to this Message

Rate this thread: