Useful Tips for Excel | AEM Community Blog Seeding

[kautuk_sahni]

Useful Tips for Excel by Vivekanand Mishra

Abstract

Useful Tips for Excel
Here are some commonly used Excel formulas, you may run into need:

Extract a portion of String - Left side of a match pattern
Formula: =LEFT(A1,SEARCH("MyTest",A1)-1)
A1 - the cell on which value to run this formula; It can be replaced with String value as needed
MyTest- the search term
Input: This is very tricky MyTest shows it rightly!
Output: This is very tricky

Extract a portion of String - Right side of a match pattern
Formula: =RIGHT(A1,LEN(A1)-SEARCH("MySecondTest",A1)-LEN("MySecondTest"))
A1 - the cell on which value to run this formula; It can be replaced with String value as needed
MySecondTest- the search term
Input: This is very tricky MySecondTest shows it rightly!
Output: shows it rightly!

Read Full Blog

Useful Tips for Excel

Q&A

Please use this thread to ask the related questions.