Saturday, May 1, 2021

How to extract a substring that comes after or before a specific symbol like @ in excel?

Use the following formula:

=RIGHT(A2,LEN(A2)-SEARCH("-",A2))
Before
=LEFT(A2,LEN(A2)-SEARCH("-",A2))

at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Headers Security Advanced & HSTS WP setup manually

Open the file for editing and paste the following snippet inside the  .htaccess file: <IfModule mod_headers.c> Header always set S...

  • Remove Autodesk software from Mac
      Uninstall products using the Remove utility For some products, you can run the Remove  ProductName  utility in the Finder > Go > App...
  • install PowerMTA on the server
    We can install PowerMTA on the server. rpm -ivh /home/PowerMTA-4.0r6.x86_64.rpm You will see the output like this Preparing... #############...
  • MacPro M1 Monterey Xforce Keygen not opening
    Instructions: Copy xf-adesk19 to your Desktop Open terminal  (Command+Space and type Terminal and press enter/return key) Paste the followin...