EXCAL

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
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
 
Back
Top