Easy Steps to Work With Text in Microsoft Excel

Microsoft Excel is generally a software program marketed towards users who need to deal with large amounts of data figures on a daily basis. However, Microsoft Excel’s capabilities and features do not just lie in manipulating data figures alone. Given the right knowledge and features, users can rely on Microsoft Excel to keep organised with text. For example, creating lists, making labels and more! If you are interested in learning how to make work with text in Microsoft Excel, here are some easy steps to get started with:

Text Wrapping

In the event that you need to input text into multiple lines, make additional comments, notes and descriptions, you can make use of the wrap text feature to keep your information reader friendly. You can use the text wrapping function by selecting the relevant cells you wish to apply the function to. If needed, you can select entire rows or columns for this process. Next, simply right click and choose the format cells option. You can then choose the alignment tab and look for the option to wrap text. To finalise the change, simply select OK. If you are using Microsoft Excel 2013 and above, you can find the wrap text function in your Home tab too!

TEXT Function

For users who need to change the method in which numbers are displayed according to situations that combine them with text, making use of the TEXT function can help greatly. An example of the TEXT function will resemble =TEXT (value to format, format code applied). Using this, you can sort information and data by examples like dates, time, names and more!

Using Text Boxes

Text boxes are an ideal feature to use when you need to group text in Microsoft Excel to create labels or categorise information. To create a text box, locate the drawing toolbar by choosing the drawing tool or looking through the view tab to select toolbar and choosing drawing as the option. Click on the text box tool and select the corner where your text bar will appear. Next, hold down the cursor and drag to the desired size of your text box. Release for the text box to be created and begin typing as usual.

Comparing Text

There are times where one finds themselves needing to compare different text in Microsoft Excel and sifting out unique values. To sift out unique information, you are recommended to rely on conditional formatting your text cells. Begin by labelling your lists clearly. Next, apply conditional formatting by choosing the home tab and selecting the conditional formatting option. You can then apply a new rule by making the relevant selection, this will then allow you to determine what rule type to use. Select using formulas to determine which cells to format as your rule type. Enter the formula as [=COUNTIF(__,__)=0]. You can then choose the colour of your highlight by selecting the format button and manually choosing the colour. Choose okay to confirm the changes.

These are just some of the easiest functions to make use of when working with text in Microsoft Excel. Once you are able to accomplish these steps, check out more comprehensive Microsoft Excel tutorials to brush up on your skills!

I am Morris Edwards working as a trainer at A1 Myob Course Singapore. which offers Skills Future Approved training in a href ="https://www.a1myobcourse.sg/"Microsoft Excel course, Accounting, Corporate Tax and MYOB courses at a low price.