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
- Display two columns in data validation list but return only one - Guide
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
- If cell contains partial text then return value in another cell ✓ - Excel Forum
- Excel count occurrences of string in column - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
