Comparing partial words in the same column
Closed
gufran
-
Jun 27, 2012 at 11:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 28, 2012 at 09:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 28, 2012 at 09:55 AM
Related:
- Comparing partial words in the same column
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- How to convert column to row in notepad++ ✓ - Excel Forum
- Excel compare two columns for partial matches - Guide
- Display two columns in data validation list but return only one - Guide
- Excel copy column from one sheet to another automatically - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 28, 2012 at 09:55 AM
Jun 28, 2012 at 09:55 AM
Hi Gufran,
Did you made a typo and meant the first 3 characters?
Could the following be a solution?:
Insert an extra column and use text to columns to split data using space as separator.
Now you can easily sort and color the three capital letters.
Best regards,
Trowa
Did you made a typo and meant the first 3 characters?
Could the following be a solution?:
Insert an extra column and use text to columns to split data using space as separator.
Now you can easily sort and color the three capital letters.
Best regards,
Trowa