Mid Statements

[kgiddens]

I have a spreadsheet that has names of computers, some of the names are for
laptops, and some are for desktops. The laptop computers can be identified
by the letter "L" in the computer name. I am trying to write a mid statement
that will filter out all the laptops, so I can put them on a seperate
spreadsheet. I cannot remember how to do a mid statement to look at the end
of the name of the computer, count in 3 places and identify if there is an L
there or not.

HELP!

 

[M Kan]

I think this would work

=LEFT(RIGHT(I23,3),1)

assuming your SKU number is in I23

 

[TWhizTom]

Mid(stringtosearch,startpostion,numcharstolook)

If you computer names always have the L in the 8th position, name is in cell
A1 and your only looking for an L...

If(mid(A1,3,1)="L","Laptop","Desktop")

 

[RagDyer]

This will return a "True" if there's an "L" there:

=LEFT(RIGHT(A1,3))="L"

 

[Rick Rothstein \(MVP - VB\)]

This will return the 3rd letter from the end of the text in A1...

=MID(A1,LEN(A1)-2,1)

The generic form of this formula (so you can see where the 2 came from) is
this...

=MID(A1,LEN(A1)-<<LetterPosition>>+1,1)

where you would put 3 in for <<LetterPosition>> as per your posting.

Rick