Removes Characters and Blank Space From The Right Side Of Contents In Cell Of Excel Worksheet

In the active cell, you have some contents inside it. For more understanding it easily, suppose you have the following data in your Excel worksheet:

In an active cell A1, it contains the data, “Remove A”, -- this data entered is composing with seven characters and one blank space between –e and A.

Now, suppose that you want to delete the last two characters from the content, the "Blank Space" and "A" letter.

Use this formula as an image shown below: 

In cell A1, to type the text: "Remove A"
In cell B1, fill out the formula: =LEFT(A1,LEN(A1)-2)

Result:

There will be just the only word “Remove” remaining in the active cell. The last two characters, the "Blank space" and "A" letter, are deleted.

Do you find this article useful?

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles:

• Excel Trick Expand Excel Column Width Fit To The Longest Data Entered
• [Ctrl] + [-](minus sign) Excel Shortcut Open Dialog Box Menu of Delete Cells, Row and Column Function
• 4 Cool Ways To “Sum” Values Of Number In An Excel Worksheet – ExcelTip2day