Excel Tips, Tricks, and Shortcuts

Today, I am going to tell you on how to move out some specified number of the characters that you have entered into active cell in your Excel worksheet. The functions for this task being done are “RIGHT” and “LEN” For more ease to deal this delete the unwanted specified characters; follow the example and image below: Within an active cell A1, input the data entered, “Please leave alone A” , -- this data entered set is with the twenty characters in text string. It is including between seventeen letters and three of bank space between each word. Now, you are going to get rid of the all the characters but A Here we go through the step by step: In cell A1, write down the text: "Please leave alone A" In cell B1, fill in this formula: =RIGHT(A1,LEN(A1)-19) Result: Eventually, the all the characters will be moved out but left only the letter “ A ”. Take this formula to apply and use for your own task. Do you find this article useful? See more another tips: ...