Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Useful Tips for Excel | AEM Community Blog Seeding

kautuk_sahni
Community Manager
Community Manager

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.

Topics

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

0 Replies