Login
Social Login
Register
Menu
Home
Forum Home
Site Home
Ancient Greek Dictionary
Help
Forum Help
FAQ
Rules
Converters...
Currency
Measurements
Polytonic to Monotonic
Greeklish
Beta Code
Gibberish
Tmx to text
Excel to tmx
Excel to MultiTerm
Utilities...
Fix final -n
Word Macros
Rule of three calculator
Greek accentuator
Fix punctuation
E-mail clean up
Calculator
What's new
Search
Forum Search
Search Tools
Magic Search
How to
Forum
EN⇄EL
All langs
Google
Greek
DE⇄EL
FR⇄EL
IT⇄EL
ES⇄EL
TR⇄EL
Resources
LA⇄EN/EL
EN🠒EL MS
AncientGR
LSJ
Translation - Μετάφραση
»
Resources, Technical Assistance and Technology News
»
Translator resources
»
Tips on Using Computers
(Moderator:
spiros
) »
Excel: Sort a list of values within a cell with any delimiter (comma, space, pipe, semicolon, etc)
Excel: Sort a list of values within a cell with any delimiter (comma, space, pipe, semicolon, etc)
spiros
·
1 ·
1245
« previous
next »
Print
Pages:
1
Go Down
spiros
Administrator
Hero Member
Posts:
855812
Gender:
Male
point d’amour
Excel: Sort a list of values within a cell with any delimiter (comma, space, pipe, semicolon, etc)
on:
12 Oct, 2022, 16:31:25
Download the free
Save time in Excel with ASAP Utilities. Easy, fast and reliable Excel tools.
1. Select the cells
2. Go to ASAP Utilities > Range > Sort values inside each cell in selection
3. Select a predefined delimiter or add yours
Up until recently this did not work with Unicode characters (i.e. Greek polytonic). From version
8-0-2_RC1
onwards, it does,
if you have Excel 2021 or Excel 365
as it uses Excel's new built-in SORT worksheet function to do the sorting.
Text › 26 Sort values inside each cell in selection... (English)
«
Last Edit: 13 Oct, 2022, 13:30:06 by spiros
»
LSJ.gr — Look up Multiple Greek, Ancient Greek and Latin dictionaries
Print
Pages:
1
Go Up
Translation - Μετάφραση
»
Resources, Technical Assistance and Technology News
»
Translator resources
»
Tips on Using Computers
(Moderator:
spiros
) »
Excel: Sort a list of values within a cell with any delimiter (comma, space, pipe, semicolon, etc)
Search Tools
Search
This topic
This board
Entire forum
Google
Bing
Username
Password
Always stay logged in
Forgot your password?