Way to combine 2 cells?

S

SF

Hi,

I have the following


A B C...
I Budgeting
I1 cccc
I2 dddd
I3 eeeee

II Office Supply
II1 aaaaa
II2 bbbb
.....

Is there a way to combine Cell A1 with B1 to display 'I - Budgeting'
 
D

Dave Peterson

=a1&" - "&b1
Hi,

I have the following

A B C...
I Budgeting
I1 cccc
I2 dddd
I3 eeeee

II Office Supply
II1 aaaaa
II2 bbbb
....

Is there a way to combine Cell A1 with B1 to display 'I - Budgeting'
Click to expand...
 
D

D Smith

You can also accomplish this by clicking "Insert" then "Function" and using
"Concatenate" under the "Text" group. You can join just about anything with
Concatenate. The function has a limit of how many items can be joined but
you can use multiple functions to combine more.

BTW: If you need the results to be fixed, ie not subject to a change in the
original cells, do a "Copy" then "Paste Special" and select "Values". This
will copy the result of the function and not the function itself.

Hope this helps!

Dave
 
Top