Using '&' in Microsoft Excel

To connect strings in Microsoft Excel, simply use '&'. 

Example :


This will return the following results:



Labels:

Shortcut to use in Microsoft Office 1

There are shortcuts that you can use in Microsoft Office to fasten your work. You need to press the same keys together. 1) Ctrl + A - to sel...

  • MIN
     Formula MIN is used to search the least value. Example of formula is =MIN(RANGE X:RANGE Y) Example 1 : To find the minimum value of a row ...
  • AVE
    Formula  AVERAGE  is used to search the average value. Example of formula  is  =AVERAGE(RANGE X:RANGE Y) Example 1 : To find the average val...
  • Using '&' in Microsoft Excel
    To connect strings in Microsoft Excel, simply use '&'.   Example : This will return the following results: