ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combining cells (https://www.excelbanter.com/excel-programming/419628-combining-cells.html)

caseysmydog

Combining cells
 
I need to connect cells a-b-c together for insertion of names, Last, First.
I know this must be simple...anyone help?
--
David

Nigel[_2_]

Combining cells
 
Do you mean concatenate the cells?

If so then use =Concatenate(A1,B1,C1)

You can also add spaces or other test as well, e.g

=Concatenate(A1," ",B1," ",C1)



--

Regards,
Nigel




"caseysmydog" wrote in message
...
I need to connect cells a-b-c together for insertion of names, Last, First.
I know this must be simple...anyone help?
--
David



caseysmydog

Combining cells
 
On the left side of my list I need a space wide enough to contain the last
and first name of an individual. Going down that left side there would be
multiple names entered.
I have cell a and b and c set aside to enter the name but don't know how to
connect them as a unit.
Thanks...
--
David


"caseysmydog" wrote:

I need to connect cells a-b-c together for insertion of names, Last, First.
I know this must be simple...anyone help?
--
David


caseysmydog

Combining cells
 
Thanks, I figured this out....
--
David


"caseysmydog" wrote:

I need to connect cells a-b-c together for insertion of names, Last, First.
I know this must be simple...anyone help?
--
David



All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com