Excel Tips and Tricks - Aptus Business Solutions
Aptus Business Solutions specialise in delivery and supporting solutions for Sage X3, Sage 300, Sage CRM and Sage Intacct. With over 30 years of knowledge, we have been supporting clients from around Australia and internationally. We cater to businesses of all sizes and business areas. Our services, support and business systems understanding enable clients to succeed and grow in their industry. We cover all aspects of system design, business processes, consultancy, hosting and IT, development and systems integration.
ERP, Consultants, Sage, Finance Management, Accounts Management, Sage 300, Sage X3, Sage Intacct, Sage Enterprise Manager, Sage CRM, Finance software, Accounts software, Business Solutions, Business Systems
16607
post-template-default,single,single-post,postid-16607,single-format-standard,ajax_fade,page_not_loaded,,side_area_uncovered_from_content,transparent_content,qode-child-theme-ver-1.0.0,qode-theme-ver-16.7,qode-theme-bridge,wpb-js-composer js-comp-ver-5.5.2,vc_responsive

Excel Tips and Tricks

Excel Tips and Tricks

How to add bullet points to a field in Excel

Using Excel, have you tried to add a bullet point within a field to stack numbers, sentences or phrases?  Adding a bullet point helps the reader to see each point clearly rather than viewing several run-on sentences or numbers.  Here are a few easy steps to add bullets within a field in Excel.

Download the workbook to practice.

In this example we are going to use sentences.  Here is a simple table where the user has included a ‘Comment’ field.  See how the sentences within the comments field run together?  We can clean up this look easily by adding bullets and/or placing each sentence (or number or phrase) to the next line.

Within the formula bar, place your cursor at the front of the sentence and select Alt plus the number 7 (Alt + 7) on your keypad. If you have a laptop without a keypad then you can either select numlock or select Fn Alt plus the number 7 (Fn+Alt+7) to insert the bullet.

Fn is the Function key typically in Blue color and used for the additional functions in blue on select keys.

To continue adding bullet points to the additional sentences, phrases or numbers simply place your cursor at the front of each sentence and again, select Alt plus 7 or Fn Alt plus 7 (for laptops without a keypad).

If you wish to see each sentence or phrase on a separate line then, in front of each bullet point, select Alt plus Enter.  This will move the rest of the sentences to the next line.

How to quickly and easily combine text from multiple columns in Excel

You don’t have to create complicated formulas to combine text from multiple columns to a single column. In this Excel tip, we will show you how to quickly and easily combine your data from multiple columns into one column.

In the example below. We have five different columns of data and we need this data to be combined into one column. We use the “&” sign to achieve this.

Download the workbook to practice.

  1. First, put your cursor into the cell in which you want the combined value, in our example we used F5.
  2. Next, put your cursor into the Formula Bar and type the equals sign, “=”
  3. Then, select the first cell you want to include which is A5 for this example, then type an ampersand sign “&” into the formula.
  4. Then, select the second cell you want to include, in our example it is B5 and follow it with an ampersand sign “&” as well. Repeat this process for all the columns that you would like combined.

For this example, the formula is: =A5&B5&C5&D5&E5

  1. Then, select the ‘enter’ key and your combination will be visible.
  2. Finally, keeping the cell selected, you should see your formula and you can hover over the small dot on the bottom right of the cell. This is the Fill. Click and drag the dot downward so that the formula is copied to the remaining rows. Or, since the column prior includes values you could simply double-click on the dot and your formula will automatically fill in all the rows

If you would like spaces between text, you will need to use the Concatenate formula.

  1. To add space between words, simply add quotation marks around a space as well as comma separators. Don’t forget the comma separators!

Your formula will be: =CONCATENATE(A5,” “,B5,” “,C5,” “,D5,” “,E5,”)

eBook: 6 Tips and Tricks on Excel Charts

http://int.elligence.co/Excel_Charts

Here is a  handy eBook which contains 6 tips and tricks that will help you make the most of Microsoft® Excel® charts. Download Now >

 

Contact us at support@aptusbusiness.com.au for further information.