![]() Press the "Enter" key to confirm your formula.Ĭlick in cell C2, then click in the formula bar and type the following: =TRIM(RIGHT(A2,(LEN(A2)-LEN(B2)+1))) This formula instructs Excel to find all the characters in the address except for the number of characters occupied by the house number, then remove the space from the beginning of that text and display the result. If your spreadsheet contains label text at the top of each column, click in cell B2 next to the address in cell A2.Ĭlick in the formula bar and type the following: =LEFT(A2,FIND(" ",A2,1)) This formula tells Excel to start at the left end of the information in cell A2 and find the first space, which should fall immediately after the house number, then display in cell B2 the information to the left of the space. ![]() Click in the cell in column B that's next to the cell that contains the first address.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |