728x90 AdSpace

Latest Article

Microsoft Excel String Functions - with Example Tutorial Online








Microsoft Excel  String Functions  Excel String Functions  Lecture Slide Notes Online Tutorial Handouts Excel 2010  with Example Excel 2012

Cell A1 => Hisham---Malik
Cell B1 => =Substitute(A1,”-”,” “) => Hisham   Malik
Cell C1 => =Search(“ “,B1) => 7
Cell D1 => =Left(A1, C1) => Hisham
Cell E1 => =Len(A1) => 14
Cell F1 => =Right(B1, E1-C1) =>    Malik
Cell G1 => =Trim(D1) => Hisham
Cell H1 => =Trim(F1) => Malik
Cell A1 => Hisham---Malik
Cell A2 => Trim(Left(Substitute(A1,”-”,” “), Search(“-“,A1)))
Cell A3 => Trim(Right(Substitute(A1,”-”,” “), Len(A1)-Search(“-“,A1)))



 Microsoft  Excel String Functions - with Example Tutorial  Online
  • Title : Microsoft Excel String Functions - with Example Tutorial Online
  • Posted by :
  • Date : 03:59
  • Labels :





  • Blogger Comments
  • Facebook Comments

0 comments:

Post a Comment

Top