In A3: =IF(A2="#",A1,"")
Copy A3 to E3

Then in F3:
=SUBSTITUTE(TRIM(A3&" "&B3&" "&C3&" "&D3&" "&E3)," ",",")
will return the required concat result
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"James" wrote:
I am not sure which excel function to use.

I need to create a formula that looks for a # in a cell and returns a
corresponding person's initials. If there are multiple occurences I need to
concatenate the initials into one cell separated by a comma.

In row 1, i have the person initials
In row 2, I have the #'s
In row 3, the formula

Therefore,

A B C D E
1 PH IS CF MS AS Row 1

2 # # # Row 2

The formula result in row 3 should be PH,CF,AS

Can anyone help?
--
J