You may have a workbook which contains
You may have a workbook which contains text but you only want to extract certain characters from it. For example, you may only want to extract the first name from a cell which contains the first and last name of a person. In this tutorial I will show you how to manipulate text and in particular, I will show you some great techniques journalworldwide on how to remove the first 4 characters in Excel using the following functions: 1) Excel RIGHT Function 2) Excel MID Function 3) Excel REPLACE Function Using the Excel RIGHT Function In this example I want to remove the first 4 characters from the postcode CV36 7BL and leave the last 3 characters. Let's assume the postcode is in cell A2 in the Excel spreadsheet. The formula in cell B2 will be: =RIGHT(A2,LEN(A2)-4) So how does this formula work? Let's break this down so you can understand how it works. RIGHT Function The RIGHT function extracts a given number of characters from the right side of a specified text. For exampl