Скачать или смотреть How to remove text before or after a specific character in Excel

While working with Microsoft Excel sheets, you might need to remove the first few characters, or last few characters, or both from the text. Removing the first few characters from a column of texts is useful when you need to remove titles (Eg. Dr., Lt.). Similarly, removing the last few characters could be useful while removing phone numbers after names.

This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel. You will learn how to:

1] Remove the first few characters from a column of texts.

2] Remove the last few characters from a column of texts.

3] Remove both the first few & last few characters from a column of texts.

Read a detailed step-by-step guide on https://www.thewindowsclub.com/how-to...