Way to combine 2 cells?

[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'

 

[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'

 

[Gord Dibben]

In C1 enter =A1 & " - " & B1


Gord Dibben MS Excel MVP

 

[Guest]

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