excel formula - check column for specific character position and populate another column -



excel formula - check column for specific character position and populate another column -

i have column of machine names. management want separate column "desktop" or "laptop" instead. 5th character can check differentiate. i've tried searching , cannot find right code. machine name column , column h need have right formula display desktop or laptop. it's 1300 rows. suggestions appreciated?

jeff

for sake of answer, quoting @jeeped:

the mid function looking for. e.g. =if(mid(i2, 5, 1)="d", "desktop", "laptop")

excel-formula

Comments

Post a Comment

Popular posts from this blog

c# - ASP.NET MVC Sequence contains no matching element -

c# - ASP.NET MVC Sequence contains no matching element - i new asp.net mvc. have finished project unusual issue appeared in project. as seek run project error message. an exception of type 'system.invalidoperationexception' occurred in entityframework.dll not handled in user code additional information: sequence contains no matching element in 1 of controller using statement below groups display in dropdownlist. http://localhost....../clients (trying run page) , getting error on line containing code below. viewbag.groupdropdownvalues = new selectlist(db.groups.orderby(m => m.groupid), "groupid", "groupname"); or other controller: viewbag.categorydropdownvalues = new selectlist(db.category.orderby(m => m.categoryid), "categoryid", "categoryname"); this happening in controllers using syntax. i need display dropdownlists values database. working correctly till morning. don't have thought changed ,
Read more

java - Parsing XML, skip certain tags -

java - Parsing XML, skip certain tags - i next mkyong's great tutorial on how parse xml in java, have situation need read tags within area. e.g. <?xml version="1.0"?> <company> <staff id="1001"> <firstname>yong</firstname> <lastname>mook kim</lastname> <nickname>mkyong</nickname> <salary>100000</salary> </staff> <staff id="2001"> <firstname>low</firstname> <lastname>yin fong</lastname> <nickname>fong fong</nickname> <salary>200000</salary> </staff> <changes> <staff id="2001"> <firstname>low</firstname> <lastname>yin fong</lastname> <nickname>fong fong</nickname> <old_salary>175000</salary> <ne
Read more

rest - How to invalidate user session on inactivity in a stateless server? -

rest - How to invalidate user session on inactivity in a stateless server? - i'm building stateless restful server backend in java, used angularjs frontend. since should stateless, don't create sessions generate access tokens, more exactly json web tokens, client has nowadays on every request. the tokens contain "expires" field acts absolute expiration date. however, have additional expiration on user inactivity. define access token valid long 24 hours if user active 1 time every 30 minutes. i implement writing database on every request , verify time between requests, seems lot of work working out of box when using application server's session management. to 100% stateless on server side need force state logic client. solution is: issue jwt 2 expiry dates (one session - 30 minutes, sec refresh - 24h) implement getting new token same user previous token (new token has new expiry date session, same refresh) reject requests when whatever expir
Read more