How do I search with Excel for cells with specific characters at the end of the string?
up vote
0
down vote
favorite
I need to know how to use pattern matching in excel.
Suppose I have 3 cells...
ABC
ABD
JGFC
I need to highlight those with C AT THE END.
This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.
microsoft-excel microsoft-excel-2016
add a comment |
up vote
0
down vote
favorite
I need to know how to use pattern matching in excel.
Suppose I have 3 cells...
ABC
ABD
JGFC
I need to highlight those with C AT THE END.
This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.
microsoft-excel microsoft-excel-2016
When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I need to know how to use pattern matching in excel.
Suppose I have 3 cells...
ABC
ABD
JGFC
I need to highlight those with C AT THE END.
This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.
microsoft-excel microsoft-excel-2016
I need to know how to use pattern matching in excel.
Suppose I have 3 cells...
ABC
ABD
JGFC
I need to highlight those with C AT THE END.
This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.
microsoft-excel microsoft-excel-2016
microsoft-excel microsoft-excel-2016
edited Nov 15 at 17:40
Mureinik
2,20351525
2,20351525
asked Nov 15 at 16:29
Nabeel Parkar
334
334
When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11
add a comment |
When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11
When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11
When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11
add a comment |
1 Answer
1
active
oldest
votes
up vote
3
down vote
accepted
For this specific example, you can use =RIGHT(A1,1)="C"
.
Depending on how similar your other use cases are, you may also want to look into the LEFT()
, MID()
and FIND()
formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
3
down vote
accepted
For this specific example, you can use =RIGHT(A1,1)="C"
.
Depending on how similar your other use cases are, you may also want to look into the LEFT()
, MID()
and FIND()
formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.
add a comment |
up vote
3
down vote
accepted
For this specific example, you can use =RIGHT(A1,1)="C"
.
Depending on how similar your other use cases are, you may also want to look into the LEFT()
, MID()
and FIND()
formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.
add a comment |
up vote
3
down vote
accepted
up vote
3
down vote
accepted
For this specific example, you can use =RIGHT(A1,1)="C"
.
Depending on how similar your other use cases are, you may also want to look into the LEFT()
, MID()
and FIND()
formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.
For this specific example, you can use =RIGHT(A1,1)="C"
.
Depending on how similar your other use cases are, you may also want to look into the LEFT()
, MID()
and FIND()
formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.
answered Nov 15 at 16:39
jsheeran
1712
1712
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375738%2fhow-do-i-search-with-excel-for-cells-with-specific-characters-at-the-end-of-the%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11