Excel Tips: Edit > Extract Data

Extract Data from Cells

Extract Numbers

How to extract decimal numbers from text string in Excel?

How to extract decimal value from string in Excel?

How to extract last number from text string in Excel?

How to extract middle name only or split names from full name in Excel?

How to extract milliseconds from time in Excel?

How to extract month and year only from date in Excel?

How to extract number only from text string in Excel?

How to extract numbers from mixed alphanumeric text strings in Excel?

How to extract numbers only from text strings in Google sheet?

How to extract or get the year, month and day from date list in Excel?

How to extract street number from address in Excel?

How to extract string from IP address in Excel?

How to extract time or hour only from datetime in Excel?

Extract Text

How to extract all but first / last word in Excel?

How to extract all but first/last character from string in Excel?

How to extract company name from email address in Excel?

How to extract domain name from URL in Excel?

How to extract domains from multiple email addresses in Excel?

How to extract extension from filename 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 first or first two words from text strings in Google sheet?

How to extract first two or n words from text string?

How to extract first/last n characters from string in Excel?

How to extract initials from names in Excel?

How to extract part of text string from cell in Excel?

How to extract postcode from address list in Excel?

How to extract state, zip code or city from address in Excel?

How to extract string between two different characters in Excel?

How to extract text before / after the second space or comma in Excel?

How to extract text before or after dash from cells in Excel?

How to extract text before/after space or comma only in Excel?

How to extract text between commas/brackets/parentheses in Excel?

How to extract text between single or double quotes from cells in Excel?

How to extract text between the second and third comma from cells in Excel?

How to extract text between two words in Excel?

How to extract text only from alphanumeric string in Excel?

How to extract username from email addresses in Excel?

How to pull or extract characters from right to left in a cell until a space is reached in Excel?

How to quickly extract a nth character from a string in Excel?

How to quickly extract email address from text string?

Extract Date

How to extract date from text strings in Excel?

How to quickly determine or extract AM and PM from DateTime string in Excel?

How to quickly extract part of date from cell in Excel?

Others

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

How to extract cell reference from formulas in Excel?

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

How to quickly extract filename from full path in Excel?