Elevate your expertise and be recognized as a true influencer! Nominations for the exclusive Adobe Community Advisor program 2023 are now OPEN.
Useful Tips for Excel | AEM Community Blog Seeding
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.
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
