Sorting data within cell

[sandubandu]

Sample Data file is attached
I have data containing:-

Column A
Medicine ID
1326| 323| 1442
1321| 320| 2447| 1442|12|133|880
100| 323| 1362| 152
32|23
1|2|3|4|5|6|7|8|9|10|11|12|13


Column B
Medicine weight
500mg|2%|60mg
125mg|2mg|60mg|30mg|30mg|60mg|90KG
500mg|2mg|10mg|30mg
2mg|6mg
9mg|8mg|7mg|6mg|5mg|4mg|3mg|2mg|1mg|21mg|32mg|5mg|76mg



what i want to do is:

Column D
Sorted Medicine ID
323|1326|1442
12|133|320|880|1321|1442|2447
100|152|323|1362
23|32
1|2|3|4|5|6|7|8|9|10|11|12|13

Column E
Sorted Medicine weight
2%|500mg|60mg
30mg|60mg|2mg|90kg|125mg|60mg|60mg
500mg|30mg|2mg|10mg
6mg|2mg
9mg|8mg|7mg|6mg|5mg|4mg|3mg|2mg|1mg|21mg|32mg|5mg|76mg


Please Help !

[jindon]

1) Select D3:E3
2) Enter =ConcSort($A3,$B3,"|") and confirm with Ctrl+Shift+Enter(array forumla entry)
3) Copy down

Please Login or Register  to view this content.

[sandubandu]

Its working :D Thanks !