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

merging two cells

ResolvedVersion 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:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.