Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Excel Tips: Calculation & Formulas > User Defined Functions

Edit

Edit > Change Cell Content

How to add space between characters or every digit in Excel?

How to add space between first name and last name in Excel?

How to insert spaces before capital letters in excel?

How to reverse text string or words order in Excel?

How to reverse text strings within cells in Google sheet?

How to scramble letters in words in Excel?

Edit > Combine

How to combine cells into a cell with space, commas and semicolon in Excel?

How to concatenate cells ignore or skip blanks in Excel?

How to concatenate only visible cells in Excel?

How to concatenate unique values in Excel?

How to easily concatenate text based on criteria in Excel?

How to reverse the text to column function in Excel?

Edit > Convert

How to convert cardinal number to ordinal number in Excel?

How to convert currency to words text in Excel?

How to convert decimal degrees to degrees minutes seconds in Excel?

How to convert formula to text string in Excel?

How to convert text strings to formulas in Excel?

How to quickly convert currency numbers to words in Excel?

How to quickly convert date to words in Excel?

How to spell out or convert numbers to English words in Excel?

Edit > Delete & Clear

How to remove all brackets from string in a range in Excel?

How to remove all characters after the first/last space from cells in Excel?

How to remove all punctuation marks (comma, quotation, apostrophe) from cells?

How to remove duplicate characters or words in string of a cell?

How to remove first comma from text string in Excel?

How to remove first or last n characters from a cell or string in Excel?

How To Remove First, Last X Characters Or Certain Position Characters From Text In Excel?

How to remove leading zeros from alphanumeric text string in Excel?

How to remove letters from strings/numbers/cells in Excel?

How to remove numbers from cells which containing texts and numbers in Excel?

How to remove numbers from text strings in Excel?

How to remove only text from cells that containing numbers and texts in Excel?

How to remove some special characters from string in Excel?

Edit > Extract

How to extract actual addresses from hyperlinks in Excel?

How to extract bold text only from a list in Excel?

How to extract capital letters or words starting with capital letter from text strings?

How to extract domain name from URL in Excel?

How to extract file extension from worksheet?

How to extract first / last / nth word from text string in Excel?

How to extract first letter of each word from cell?

How to extract initials from names in Excel?

How to extract text based on font color from a cell in Excel?

How to extract text only from alphanumeric string in Excel?

How to quickly extract email address from text string?

How to quickly extract filename from full path in Excel?

Edit > Fill cell content

Get and insert the created time and last modified time in cells

How to generate random character strings in a range in Excel?

How to generate random weekday or weekend date in Excel?

How to get and insert the last modified user name in Excel?

How to get current time zone and display in cell in Excel?

How to get current workbook name in Excel?

How to get the next sheet name in Excel workbook?

How to insert last saved timestamp into worksheet cell in Excel?

How to insert random (integer) numbers between two numbers without repeats in Excel?

How to reference tab name in cell in Excel?

How to reference worksheet by index number instead of name in Excel?

Edit > Split

How to separate text and numbers from one cell into two columns?

How to split / separate alphanumeric strings into two columns in Excel?

How to split by delimiter and transpose cells in Excel?

How to split text into separate columns by capital letter in Excel?

Edit > Others

How to convert carriage return to comma in Excel?

How to copy source formatting of the lookup cell when using Vlookup in Excel?

How to find all combinations that equal a given sum in Excel?

How to hide rows based on cell color in Excel?

How to quickly find the position of first letter (alpha) from string in Excel?

How to quickly find the position of first uppercase in Excel text string?

How to replace accented characters with regular characters in Excel?

How to select cells randomly in Excel?

How to transpose data from column into one single cell in Excel?