To remove a part of text in Excel, you can:
• Select a range of cells where you want to remove a specific character.
Press Ctrl + H to open the Find and Replace dialog. In the Find what box,
type the character. Leave the Replace with box empty. Click Replace all.
• Press Ctrl & F to bring up the Find and Replace dialog. Select the ‘Replace’
tab. Under ‘Find what’ put Text, leave ‘Replace With’ blank. Ensure ‘Match
entire cell content’ is unchecked.
• Use the SUBSTITUTE function. For example, to remove hyphen signs (“-“) in
a text, use the following formula: =SUBSTITUTE(B3,"-","").
To remove a part of text in Excel, you can:
• Select a range of cells where you want to remove a specific character.
Press Ctrl + H to open the Find and Replace dialog. In the Find what box,
type the character. Leave the Replace with box empty. Click Replace all.
• Press Ctrl & F to bring up the Find and Replace dialog. Select the ‘Replace’
tab. Under ‘Find what’ put Text, leave ‘Replace With’ blank. Ensure ‘Match
entire cell content’ is unchecked.
• Use the SUBSTITUTE function. For example, to remove hyphen signs (“-“) in
a text, use the following formula: =SUBSTITUTE(B3,"-","").
To remove a part of text in Excel, you can:
• Select a range of cells where you want to remove a specific character.
Press Ctrl + H to open the Find and Replace dialog. In the Find what box,
type the character. Leave the Replace with box empty. Click Replace all.
• Press Ctrl & F to bring up the Find and Replace dialog. Select the ‘Replace’
tab. Under ‘Find what’ put Text, leave ‘Replace With’ blank. Ensure ‘Match
entire cell content’ is unchecked.
• Use the SUBSTITUTE function. For example, to remove hyphen signs (“-“) in
a text, use the following formula: =SUBSTITUTE(B3,"-","").
To remove a part of text in Excel, you can:
• Select a range of cells where you want to remove a specific character.
Press Ctrl + H to open the Find and Replace dialog. In the Find what box,
type the character. Leave the Replace with box empty. Click Replace all.
• Press Ctrl & F to bring up the Find and Replace dialog. Select the ‘Replace’
tab. Under ‘Find what’ put Text, leave ‘Replace With’ blank. Ensure ‘Match
entire cell content’ is unchecked.
• Use the SUBSTITUTE function. For example, to remove hyphen signs (“-“) in
a text, use the following formula: =SUBSTITUTE(B3,"-","").
To remove a part of text in Excel, you can:
• Select a range of cells where you want to remove a specific character.
Press Ctrl + H to open the Find and Replace dialog. In the Find what box,
type the character. Leave the Replace with box empty. Click Replace all.
• Press Ctrl & F to bring up the Find and Replace dialog. Select the ‘Replace’
tab. Under ‘Find what’ put Text, leave ‘Replace With’ blank. Ensure ‘Match
entire cell content’ is unchecked.
• Use the SUBSTITUTE function. For example, to remove hyphen signs (“-“) in
a text, use the following formula: =SUBSTITUTE(B3,"-","").
