Useful Tips for Excel | AEM Community Blog Seeding

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

16-08-2020

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.