Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

Useful Tips for Excel | AEM Community Blog Seeding

Avatar

Administrator

BlogImage.jpg

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.



Kautuk Sahni
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies