Get First and Last Name Excel from Name
Get First and Last Name Excel To get First and Last Names in excel, excel users can use the combination of LEFT, RIGHT, SEARCH, & FIND Functions. If you have a list of full names and want to split the full names into first and last names as shown below, you can easily do so […]
Excel SUBSTITUTE Function (10 Examples)
Excel SUBSTITUTE Function The Excel SUBSTITUTE Function replaces existing text with new text defined by the users. Excel users use the SUBSTITUTE function to replace specific text in a text string. To replaced text in a specific location in a text string, users should use Excel REPLACE Function. Advertisements Example list: How to substitute a […]
Excel REPLACE Function (11 examples)
Excel REPLACE Function The Excel REPLACE Function replaces part of a text string with a different text string, and the function works based on the position and number of characters of the text. Examples Advertisements How to replace the first word in excel. How to replace the second character of the first word. How to […]
Excel TOROW Function ( 2 Examples)
Excel TOROW Function On March 16, 2022, Microsoft announced 14 new Excel functions. Most of them are text functions. The new Excel TOROW function is one the most useful functions. It is high time to learn about this function. Summary Advertisements The Excel TOROW function s very similar to TOCOL function, except that you get […]
Excel TOCOL Function (2 Examples)
Excel TOCOL Function On March 16, 2022, Microsoft announced 14 new Excel functions. Most of them are text functions. The new Excel TOCOL function is one the most useful functions. It is high time to learn about this function. Summary Advertisements When you have multiple columns and NEED to combine them into a single column, […]
Excel TEXTSPLIT Function (3 Exampples)
Excel TEXTSPLIT Function On March 16, 2022, Microsoft announced 14 new Excel functions. Most of them are text functions. The new Excel TEXTSPLIT function is one the most useful functions. It is high time to learn about this function. Summary Advertisements Before this function, users had to use Power Query or Mega formula made up […]
Excel CHOOSEROWS Function (3 Examples)
Excel CHOOSEROWS Function On March 16, 2022, Microsoft announced 14 new Excel functions. Most of them are text functions. The new Excel CHOOSEROWS function is one the most useful function. It is high time to learn about this function. Example list Advertisements Example 1: Keep rows 2, 4, and 6 Example 2: Keep the first and last […]
Excel CHOOSECOLS Function (2 Examples)
Excel CHOOSECOLS Function On March 16, 2022, Microsoft announced 14 new Excel functions. Most of them are text functions. The new Excel CHOOSECOLS function is one the most useful function. It is high time to learn about this function. The new CHOOSECOLS function returns the specified number of columns from an array. Advertisements Syntax =CHOOSECOLS(array,column_num1,[column_num2],…) […]
Excel DROP Function (2 Examples)
Excel DROP Function On March 16, 2022, Microsoft announced 14 new Excel functions. Most of them are text functions. The new Excel DROP function is one the most useful function. It is high time to learn about this function. Summary: Advertisements The new Excel drop function drops a specified number of contiguous rows or columns […]
Excel TAKE function (2 examples)
Excel TAKE Function On March 16, 2022, Microsoft announced 14 new Excel functions. Most of them are text functions. The new Excel TAKE function is one the most useful function. It is high time to learn about this function. Summary: Advertisements The new Excel TAKE function returns a user specified number of contiguous (adjacent) rows […]