80.0k views
2 votes
How to delete everything after a character in excel

User Jleleu
by
8.2k points

1 Answer

2 votes

Final answer:

To delete everything after a character in Excel, use the LEFT function and the FIND function with an example provided.

Step-by-step explanation:

To delete everything after a character in Excel, you can use the LEFT function and the FIND function. For example, if you have a cell containing the text 'Hello, World!' and you want to delete everything after the comma, you can use the formula =LEFT(A1, FIND(',',A1)-1). This formula will return 'Hello' as the result.

User Capikaw
by
7.8k points