Advanced String Manipulation Using MS Excel
(Page 1 of 4 )
If you haven't heard of the Mid, Find, and Len functions in Microsoft Excel before, there's no time like the present to learn. These are advanced functions that allow you to do string manipulation. You may or may not know what that is, but if you're interested in saving time and getting more out of your work with spreadsheets, keep reading.
Let's make a realistic scenario. Say your boss has assigned you to do some job that requires your skills in Microsoft Excel. You then open your Excel spreadsheet and paste in your data. BANG! You do not know the functions that will give you your desired output. You search the Excel Help, and then become confused even further.
Your deadline is approaching; you spend a lot of time finding those answers. You have no choice but to manually perform the strenuous spreadsheet manipulation without the use of those functions. You hit the deadline with the work unfinished; you failed and get a low job rating from your employer.
Its time to learn some Excel functions before this type of situation happens to you.
String manipulation in Excel is highly useful in an office environment, particularly if you're working in the engineering, information technology and business sectors. MS Excel offers several built-in functions to enable you to make your spreadsheet work easier and more efficient.
In this tutorial, we will cover the three important string manipulation functions considered to be advanced in MS Excel skill sets. These are:
- The MID function
- The FIND function
- The LEN function
Next: The MID Function in MS Excel >>
More BrainDump Articles
More By Codex-M
/ 4 
