merging two cells

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Merging two cells

Merging two cells

resolvedResolved · Low Priority · Version 2007

Philip has attended:
Excel Intermediate course

Merging two cells

How do you merge two seperate cells into one?

E.g. Excel / Forum into Excel Forum down an entire page

Thanks

RE: Merging two cells

Hello Philip

Thank you for your question and welcome to the forum.

You should be able to use the Concatenate function to join the contents of two cells togehter, this would have to be done in a third cell.

Alternatively you can use Find and Replace if you wanted to replace every single instance of Excel with Excel Forum.

If you require further information on either of these, please let me know.

Kind regards
Amanda


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.08 secs.