Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if then statements | Excel Discussion (Misc queries) | |||
IF & OR Statements | Excel Worksheet Functions | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
if statements help | New Users to Excel | |||
If Statements... | Excel Discussion (Misc queries) |