<\/figure>\n\n\n\nTo get the first three letters use this formula.<\/p>\n\n\n\n
=LEFT(A2,3)<\/pre>\n\n\n\nFor the numbers, we are going to use the RIGHT<\/strong> function.<\/p>\n\n\n\n=RIGHT(A2,6)<\/pre>\n\n\n\n <\/figure>\n\n\n\nGet the first x characters before a character<\/h2>\n\n\n\n Now, we are going to deal with a more complicated problem. The example below shows numbers separated by dashes.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe want to get the first part of the number. We can\u2019t get the first x numbers because the number of characters before the dash is not constant. But we can modify the formula to do the job.<\/p>\n\n\n\n
=LEFT(A2,FIND(\"-\",A2)-1)<\/pre>\n\n\n\nThe FIND<\/strong> method returns the position of the first dash minus 1.<\/p>\n\n\n\nGet the first x characters after a character<\/h2>\n\n\n\n In the previous example, we could see how to get the first characters before a specific character. Now we are going to get a fixed number of characters after a character.<\/p>\n\n\n\n
=RIGHT(A2,LEN(A2) - FIND(\"-\",A2))<\/pre>\n\n\n\n <\/figure>\n\n\n\nThe LEN<\/strong> function gets the number of characters minus the first occurrence of the dash.<\/p>\n\n\n\n11 \u2013 4 = 7.<\/p>\n\n\n\n
In other words, the formula gets 7 characters from the RIGHT<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"Whether you want to display the first x characters from the identification card or a zip code there are a few ways you…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,190],"yoast_head":"\n
Get the First x Characters in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n