This tutorial is compiled using Excel 2007 but should work on all versions of Microsoft Excel.
Often when using Excel you want to keep values in separate columns but also present them together. For example, when compiling a list of names you would want:
- First Name
- Surname
- Full Name
You may also then want to add in numerical data as well. Let’s say this is for a customer list you may want customer ID and date contacted. Now your columns look like this:
- First Name
- Surname
- Full Name
- Customer ID
- Date Contacted
- All Details
Immediately you realise that all the data in the ‘Full Name’ and ‘All Details’ columns is already entered. Instead of typing everything out twice – which often results in mistakes – you can use an Excel function to join multiple cells together. Here is how to join cells containing text and numbers: Read the rest of “Joining Cells in Microsoft Excel 2007 Tutorial”
This is the complete list of every Excel Function for text. For each function I have provided a description, the formula and in some cases an example. Where text is necessary I have included the word ‘text’ as an example and where a target cell is specified I have used ‘A1′. Where appropriate I have provided links to other uses for the functions.