Left Function
I am trying to pull certain characters based on a criteria for the third
position character. In Column A, I could have a code such as BB11 or a Code such as BMR2. If the third position character is a number then I only want to pull the first 2 digits BB but if the third position character is a letter, then I would like to pull the first 3 characters BMR. Can anyone help? -- AJ |
Left Function
Try this
=LEFT(A1,3-(ISNUMBER(MID(A1,3,1)+0))) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "AJ" wrote: I am trying to pull certain characters based on a criteria for the third position character. In Column A, I could have a code such as BB11 or a Code such as BMR2. If the third position character is a number then I only want to pull the first 2 digits BB but if the third position character is a letter, then I would like to pull the first 3 characters BMR. Can anyone help? -- AJ |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com