Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

need help with some excel formulas for multiple cells looking at a string

using the attached sample I want to interrogate cell C and fill columns E,F & G

Logic

Cell E
should be Ipad if cell C starts with I or Ipad
should be Cell  is cell C starts with C
Should be PC if cell C starts with P or PC

Cell F
should be the extract of the four digit employee # always four digits, if four digits are missing leave blank

Cell G
should be the extract of the employees name from cell Ctest alphacorp.xlsx
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial