Excel Formula

Get the Current Workbook Name

This post explains how to get the current workbook name in excel. Get the Current Workbook Name In excel, the CELL function can get the information of the current worksheet, it will return the full file name and its path. If you want to get the name of the current workbook only, you can use… read more »

Split Text and Numbers in Excel

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can run the following excel formula that use the MIN function, FIND function and the LEN… read more »

Split Text String by Specified Character in Excel

This post explains how to split text string by a specified character (such as: comma, space, dash, slash, etc.) using FIND function within other functions in excel. And you will learn that how to extract part of characters to the left of a specified character in one cell. Split Text String by Specified Character When… read more »

Excel Replace Function Remove Text String

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you can use the REPLACE function. It can remove the text string by position in a… read more »

Combining the Replace function with Text function in Excel

In excel, we can use Replace function in combination with Text function to replace date characters that are part of the text string. And this post will guide you how to use TEXT function as the first arguments to replace text string in REPLACE function in excel 2013. We have talked in the previous post… read more »

Excel Replace function with numeric values

In excel, how to replace a numeric characters within a text string using another numeric characters. This post will guide you how to use REPLACE function to replace numeric characters using another numeric characters in one text string. The Excel REPLACE function replaces all or part of a text string with another text string The… read more »

Convert date to month and day only in excel

In excel, how to get the month and day string from an excel date value. How to convert the dates to text string, just only display as month and day. This post will guide you how to convert date to month and day value only using Text Function in Microsoft Excel. Convert date to month… read more »

Convert date to month and year only in excel

In excel, how to get the month and year string from an excel date value. How to convert the dates including both date and time to text string, just only display as year and month. This post will guide you how to convert date to month and year value using Text Function in Microsoft Excel…. read more »

Convert date to month name with Text Function in Excel

This post will guide you how to convert date to month name (text string) from an excel date using Text Function in Microsoft Excel. or how to get the month name from a date value in excel. The Excel TEXT function converts a numeric value into text string with a specified format. You can convert… read more »

Convert Date to text with Text Function in Excel

This post will guide you how to convert dates to text string using Text Function in Microsoft Excel. The Excel TEXT function converts a numeric value into text string with a specified format. You can convert all the standard number formats such as: dates, times, currency to Text string in excel. The Date and Time… read more »

Three Ways to Convert Number to Text in Excel

Before we have wrote a post to describe that how to convert number to Text string with Text Function in excel. This post will guide you how to convert number to Text using The Format Cells Command and Text to Columns wizard in excel. Convert Number to Text Using Format Cells Option You also can be… read more »

Excel Convert numbers to Text

This post will guide you how to convert numbers to text with the Excel TEXT function. Assuming that you want to display leading Zero in numbers in cell, then you need to convert them into Text based on the specified Format_text. So you can use TEXT function to achieve this in Excel. The Text function will… read more »

Sidebar