Mid Statements
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!
|