Excel String/Text functions with examples..

Basic Text Functions

"Thanks you everyone for your response. Today we are going to discuss Excel's strings / text functions. These functions will help you create a strong base. I am not saying you always need them but if you know them you can definitely work faster in Excel."

Lets start the functions :)

• LEFT - Take out specific number of characters from the left. 

• MID - Take out specific number of characters from Middle (can be left or right as well).

• RIGHT - Take out specific number of characters from the Right.

• FIND - Find any specific text, within text (case sensitive)

• SEARCH - Find any specific text, within text (not case sensitive).

• SUBSTITUTE - It changes text to some other text provided by user.

• REPLACE - It changes text to some other text provided by user.

• TEXT - It take cares all the formats you want in Excel.

• REPT - It repeats the characters.

• CONCATENATE - Merge text or numbers, It was concatenate but new excel version has been changed to concat.

• CODE - Converts value to code/Asc.

• CHAR - Converts value to char/chr.

• NUMBERVALUE / VALUE - Convert text into numbers.

• PROPER - Make strings to proper case

• UPPER - Make strings to upper case

• LOWER - Make strings to lower case

•  TRIM - Remove extra space.

• CLEAN - Clean data, remove non printable characters

• DOLLAR - Put a dollar symbol before the numbers.

• T - Test whether you have test or number.

• EXACT - Compare binary formats (case sensitive).

• LEN - Count the length of a text or number.

Here is the sample file you can use it to practice where I have created some of the samples.

                            Download File...

Here is the Youtube video, where I have explained everything..

 

Please get in touch for any query help or suggestion..
Youtube
Facebook Page
Twitter
Email: lkthecool@gmail.com