![]() ![]() Enter the following formula in an empty cell =LEFT(A4, LEN(A4)-4)ģ. Conversely, you can use the right Function to remove the first characters from the beginning of a text string.Ģ. If you are removing the last characters the left function is the most appropriate to use. The best thing about all this is that you can remove these characters using a simple formula/ function or using software known as KUTOOLs. That is the characters on your left or right. In this tutorial, we are going to look at how you can eliminate the last 4 characters.Īpart from removing the last characters, you can also remove the first characters that you do not need. ![]() Luckily, Excel allows you to get rid of the extra characters. Sometimes you may get data attached to some other data that you don't require.
0 Comments
Leave a Reply. |