ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Left Function (https://www.excelbanter.com/excel-discussion-misc-queries/261955-left-function.html)

AJ[_4_]

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

Mike H

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