EXCAL

[Guest]

I am trying to merge colum F and G to make one cell

 

[Guest]

Maureen -

Left Click on column "F" and drag to "G" (or whatever
column you want) - then, with the columns highlighted,
right click the columns.
Choose "Format Cells"
Then choose "Alignment tab" in the window that pops up
Place a check mark in the 'merge cells' box and press 'ok'

Now, Columns F and G are merged.
-Marshal

 

[RagDyer]

Without a space between the data:

=F1&G1

With a single space between:

=F1&" "&G1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am trying to merge colum F and G to make one cell

 

[scott]

if it's text then =f1&g1

 

[RagDyer]

This will merge the cells BUT *delete* the data in Column G !
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Maureen -

Left Click on column "F" and drag to "G" (or whatever
column you want) - then, with the columns highlighted,
right click the columns.
Choose "Format Cells"
Then choose "Alignment tab" in the window that pops up
Place a check mark in the 'merge cells' box and press 'ok'

Now, Columns F and G are merged.
-Marshal

 

[Gina]

open the cell with = enter first cell enter & then enter
second cell - the formula should look like this if you are
on line 1:
=f1&g1