On Sep 22, 10:55*am, Gord wrote:
You posted in programming group so assumed you could handle
programming.

I can't think of any worksheet formula solution at the moment. *I'm
sure someone will jump in with a worksheet function solution for you.

In the meantime this might be a good time to start to learn VBA which
is a powerful adjunct to Excel and would make your Excel life so much
easier IMO.

What I posted was a User Defined Function.

To set it up.........................

With your workbook open hit Alt + F11 to open the Visual Basic Editor.

CTRL + r to open the Project Explorer.

Select your workbook/project and right-clickinsertmodule

Paste the UDF into that module. *Save the workbook. *Alt + q to return
to Excel.

In a cell enter *=concat(B1:B6)

Gord

On Thu, 22 Sep 2011 10:35:49 -0700 (PDT), cardan



wrote:
Hi Gord, *Thank you for the quick reply. *Would there be a way to do
this with just formulas? *My VBA skills are not that great and I am
not familiar (and confident) with inputting code. *Thanks again.- Hide quoted text -

- Show quoted text -

Hi Gord, Thank you for the input. I usually do some complex formula
writing and found I get the best reponses here, so I usually asked my
questions here under the programming group. Also sometimes I have to
share the models and sometimes others don't know anything about macros
(less than I do) so I will stay away from them (and sometimes arrays
too).

I followed your instructions and it works great. One question I do
have, is if I wanted to copy that formula over to other columns, how
can I make it so that it will reference the names in Column A, but
adjust based on the values within another column. It is my fault for
not being specific enough. I figured I would keep my question as
simple as possible since I can always copy a formula easily. Thank
you again for your assistance.