merging two cells
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Merging two cells

resolvedResolved · Low Priority · Version 2007

replyReply Tue 21 Apr 2009, 15:49Delegate Philip said...

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

For upcoming training course dates see: Pricing & availability

replyReply Tue 21 Apr 2009, 15:53Trainer Amanda said...

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

 

Please browse our web site to find out more about
excel training in uk and other Microsoft training courses.

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard