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!

I think this would work

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

assuming your SKU number is in I23
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"kgiddens" wrote:

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!

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")



"kgiddens" wrote:

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!

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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kgiddens" wrote in message
...
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!

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


"kgiddens" wrote in message
...
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!