Shubhra
Content Specialist

Meet Shubhra Anand Jain, a skilled SEO specialist, and an Excel aficionado.Â With more than 5 years of experience in the field, she has developed a profound understanding of how crucial Excel is for data analysis and record-keeping.Â

In addition to her professional expertise, Shubhra is an ardent Excel user who enjoys sharing her knowledge with others. She firmly believes that Excel is a powerful tool that can simplify many complex tasks and improve efficiency in various aspects of life. Shubhra strives to make complicated tasks more manageable by teaching effective Excel formulas and functions.

She currently resides in Sweden and loves her coffee. Shubhra understandsÂ that Excel can be overwhelming, but she is here to simplify it one Excel formula at a time.Â

HejdÃ¥ for now.Â

Excel TEXTAFTER Function â€“ How To Use

The TEXTAFTER function returns the text that appears after a given character, substring, or delimiter. If the delimiter is used more than

Excel TEXTSPLIT Function â€“ How To Use

The TEXTSPLIT function separates the input text into columns and/or rows as per the given delimiter. The resulting text is spilled into

Excel TEXTJOIN Function â€“ How To Use

The TEXTJOIN function joins text or strings from multiple cells into one cell separating them using the given delimiter with an option

Excel NUMBERVALUE Function â€“ How To Use

The NUMBERVALUE function converts a number in text format to numerical format using the given decimal and group separators. The NUMBERVALUE function

Excel REPLACE Function â€“ How To Use

The REPLACE function replaces the specified number of characters from the string based on the starting position with the mentioned text, string,

Excel PROPER Function â€“ How To Use

The PROPER function alters the text into proper case by converting the first letter of each word in a string to uppercase.

Excel UPPER Function â€“ How To Use

Since Excel doesn't allow the inbuilt functionality of altering case types as Microsoft Word does, the UPPER function helps change the text

Excel LOWER Function â€“ How To Use

The LOWER function in Excel is a text function that converts all other cases to lowercase. The return value of the LOWER

Excel REPT Function â€“ How To Use

The REPT function in Excel is used to repeat the input text a given number of times. Irrespective of the format of

Excel LEN Function â€“ How To Use

The LEN Function, also called the "length" function in Excel, determines and returns the total length of the given string. To calculate

Excel FIXED Function â€“ How To Use

The FIXED function in Excel rounds off the input number as per the required decimal places and converts the number to text

Excel DOLLAR Function â€“ How To Use

The DOLLAR function is categorized as a text function in Excel. It converts a number to text but in currency format. The