Next Live Training Date:

20-22 January 2014

TEXT functions in Excel Tutorials

TEXT functions in Excel Tutorials

Excel formula and functions that help with manipulating text in excel cells. Below are some video clips of extremely useful text functions built into Microsoft Excel.

The FIND function allows you to search for a particular character within some text which is especially useful when trying to extract parts of the text.

Excel Help File Description: FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text. You can also use SEARCH to find one text string within another, but unlike SEARCH, FIND is case sensitive and doesn’t allow wildcard characters.

The LEN function tells you how many characters make up a cell which is particularly useful when trying the manipulate the text within the cell.

Excel Help File Description: LEN returns the number of characters in a text string.

The Concatenate (or &) can be used to join up the contents of multiple cells into one cell. This text function is extremely useful for generating unique keywords or preparing intelligent reports.
Excel Help File Description: Joins several text strings into one text string

These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.
Excel Help File Description: Lower and Upper converts all uppercase (lowercase) letters in a text string to lowercase (uppercase). Proper capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters

These text functions give you the ability to to extract certain segments of a cell (normally text). Useful if only part of a cell’s text contains the information you want..
Excel Help File Description: LEFT (RIGHT) returns the first (last) character or characters in a text string, based on the number of characters you specify. MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Handy Tips & Tricks

2014 World Cup Spreadsheet With the draw for the Brazil 2014 Soccer World Cup over, we have updated our 2014 World Cup Spreadsheet. As with the other prediction spreadsheets we have created for sport events, you will be able to … Continue reading

Excel round to nearest 1000

Excel round to nearest 1000 Most people are aware of how to use the ROUND functions to round numbers to various decimal levels e.g. 5.5678 to either 5.568 or 5.57 or 5.6 or 6 depending on what you specify the … Continue reading

AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.

– Sasol Polymers

Solver Excel 2013

• 04:49
• Skill Level:
• What's my skill level

Offset Excel 2013

• 06:17
• Skill Level:
• What's my skill level

Vlookup Approximate Match

• 04:55
• Skill Level:
• What's my skill level

Vlookup Exact Match

• 06:31
• Skill Level:
• What's my skill level