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)

How to Activate Windows 10/11 using digial license.

1. Open PowerShell: Click your Search bar, type PowerShell, and open it. If the installation of Windows 10/11 has been completed before. 2....