Last, First Name with Possible Middle Initial/Name This is very similar to the last set of formulas, except we are looking for a comma/space (", ") instead of just a space, and the last name is on the left, first name on the right. In our second example, our full name is in the format Last, First. Similarly to the first name, we use FIND to find out where the space is, but this time we add 1 because our last name starts after the space. To find the last name, we count from the right of the cell, and we want everything after the space. We use the FIND function to find the space, and then subtract 1 because we want to end at the character before the space. In other words, the number of characters we want is one less than the position of the space. To find the first name, we start reading at the left of the cell, and stop right before the first space. =RIGHT(which cell to look in, how many characters you want) =LEFT(which cell to look in, how many characters you want) This is the "syntax" of the LEFT and RIGHT functions, or how they want you to give them the information they need: whatever is in the cell) from the left of a cell (in other words, the beginning of text in a cell), while RIGHT does the same from the right (end of the text in a cell). LEFT gives you a specified number of characters (these could be letters, numbers, spaces, etc.
A better finder rename 10 name from spreadsheet how to#
This is a good demonstration of how to use the LEFT and RIGHT functions. In our first example, the full name is in the format FirstName LastName.Īssuming the full name is in cell A2, here are the formulas: