LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
if then statements doug Excel Discussion (Misc queries) 1 November 25th 07 07:44 PM
IF & OR Statements JG14 Excel Worksheet Functions 4 May 25th 07 11:47 PM
IF Statements (Mutliple Statements) Deezel Excel Worksheet Functions 3 October 19th 06 06:13 AM
if statements help Smurphy New Users to Excel 2 February 6th 06 09:23 PM
If Statements... Delaina Excel Discussion (Misc queries) 4 August 1st 05 10:29 PM


All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"