Hi!
Once again, I need your help, please!
I have some data in A2:Axx, it could be like this:
fgh;;;xyz;;stu;mno;;;;;;;;;xyz;;;;abc;abc;;def;;;;;;abc
(semicolons represent blanks)
Now I need a formula in B2 that sorts my data in alphabetical order, disregarding the blanks, so that B2:Byy is like
abc;abc;abc;def;fgh;mno;stu;xyz;xyz;;;;;;...
Is there a way?
I mustn't use VBA, since the file is to be sent to very weird people with strange options to activate any VBA...
Thanks a lot in advance!
Once again, I need your help, please!
I have some data in A2:Axx, it could be like this:
fgh;;;xyz;;stu;mno;;;;;;;;;xyz;;;;abc;abc;;def;;;;;;abc
(semicolons represent blanks)
Now I need a formula in B2 that sorts my data in alphabetical order, disregarding the blanks, so that B2:Byy is like
abc;abc;abc;def;fgh;mno;stu;xyz;xyz;;;;;;...
Is there a way?
I mustn't use VBA, since the file is to be sent to very weird people with strange options to activate any VBA...
Thanks a lot in advance!