If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|