| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| LEFT function-all to left of a comma? | Excel Worksheet Functions | |||
| Help with LEFT function | Excel Discussion (Misc queries) | |||
| Left vs Left$ function | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
![AJ[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
