Sortuniq not sorting, Trim, not trimming, and not leading zero

**david gonzalez** · 01-21-2014, 12:27 AM

Hi, please need advice, i don't know what i'm doing wrong

I'm extracting strings from single cells.
These Cells contain digits Numbers including front zero.

(Cell C15:C21, T15:T21, etc,etc)

I need to Extract from original Cell and copy in to a Single Cell AO3 (Down,)
-with numbers Sorted (least to most)
-with "-" (dash) between each numbers and
-Leading zero, But i excel doe's the job partially (well is not excel, it's me,

I need to get this result :

Cell
Row
AO3 02-08-11-16-25-28
AO4 02-08-16-18-30
AO5 02-05-08-09-12-16
AO6 02-08-16-18-30-33
AO7 02-06-08-16-23-32

But i'm getting with extra "dash" in some of the string, also not sorted and not leading zero.
I set the Cell properties to accept leading zero... (do i'm missing something?)

I'm Getting this Undesired result, instead :
(scramble)

Cell
Row
AO3 11-16-2-25-28-8
AO4 16-18-2-30-8
AO5 12-16-2-5-8-9
AO6 -16-18-2-30-33-8
AO7 -16-2-23-32-6-8

I have a VB code and using Sortuniq

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you

**david gonzalez** · 01-21-2014, 02:28 PM

Hi, this is david again,

Last night had a crash with my Win XP,

This is the Sample File, where i'm getting the problem..

Question: Conditional format it might causing this?,
Because i tried in brand new sheet the SortUnique formula and macro,
and it worked fine..

Thanks

Best Regards

David

**david gonzalez** · 01-22-2014, 03:28 PM

Thanks guys,

Problem Fixed,

Might some one is going to need some help,
So let me share what i did:

Next to a Column AO3 (on Column AP3)
I Insert the Formula :

Please Login or Register  to view this content.

Copy the formula down the column

Such Formula Trim de First and Last "-" (dash), at sametime for unknown reason, this formula help
to recognized the Leading zero on each single digit, So,

the String looks Sorted, Trimmed the front and Last "-", Keep dash between digits, and recognize the Leading Zero as I need it.

Thank you so much

Best Regards from Cold miami.

David