Oline IT:Blog
Innovation Technology
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))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Replace old IP with New one in Direct Admin
./ipswap.sh Old_IP New_IP for example: ./ipswap.sh 35.224.2.88 104.197.113.37
Office 2019 Activation without Product Key using CMD
Put the following code in a TXT file and save as "file.cmd" then run the cmd file as administrator. @echo off title Activate Micr...
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...
No comments:
Post a Comment