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

microsoft excel courses london - split cells

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses london - Split Cells

microsoft excel courses london - Split Cells

ResolvedVersion Standard

Emma has attended:
Excel Introduction course

Split Cells

How can you split text in cells? Thanks!

RE: Split Cells

Hi Emma,

I'm not sure exactly what you're after. An example of what you're trying to do would be useful.

If you're talking about wrapping the text in a cell, right click the cell -> Format Cells... -> Alignment tab -> tick Wrap Text checkbox.

If you're talking about using functions to split up text in a cell, have a look at this article on microsoft's web site which details functions on splitting up text and distributing the chunks into cells of their own.

You can also use Excel's Text to Columns facility. Select the column and choose Data -> Text To Columns... and then follow the wizard.

I'd recommend you always save or backup your file before making such changes.

If this solves your query, please mark this question as resolved. If you have a further question, please post a reply and we'll get back to you as soon as we can. Thanks.

Regards, Rich.

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

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.11 secs.