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
BedrockMission!

Learn More

View all

Sign in to view all badges

Useful Tips for Excel | AEM Community Blog Seeding

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,128 likes

Total Posts

6,135 posts

Correct Reply

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

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,128 likes

Total Posts

6,135 posts

Correct Reply

1,144 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.

AEM AEMEBlogSeeding Experience Manager