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.
FIND- click here to watch the video tutorial
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.
LEN- click here to watch the video tutorial
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.
Concatenate and &- click here to watch the video tutorial
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
Lower, Upper, Proper- click here to watch the video tutorial
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
Left, Right, Mid- click here to watch the video tutorial
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
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 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