Yes, I thought that myself to begin with, then I realised that he had
posted into the newusers group, so I decided not to read too much into
it.

Pete

On Aug 8, 12:49 am, "Peo Sjoblom" wrote:
Yes they will, somehow I assumed the OP wouldn't have asked this unless
there was more to it than meets the eye

--
Regards,

Peo Sjoblom

"Pete_UK" wrote in message

ups.com...



Hi Peo,

don't you think that the password values (as quoted by the OP) will
sort correctly, without needing helper columns?

Pete

On Aug 7, 11:44 pm, "Peo Sjoblom" wrote:
You need 2 help columns, preferably in D and E

assume you have headers, so in D2

=LEFT(C2)

in E2

=MID(C2,2,3)

copy down by double clicking the lower right corner of E2 after select D2
and E2
then if you want to sort by password sort by the first help column and
secondly the
second help column. If needed create a help column for the last character
in
the pw

=RIGHT(C2,1)

--
Regards,

Peo Sjoblom

"Michael Slater" wrote in message

m...

I have a spreadsheet that contains 3 columns:

Col A = Names
Col B = Dates of Birth
Col C = An Assigned Password

The passwords are formatted as follows: A001Z, B002Y, C003X,
etc...through
all rows.

The spreadsheet contains approximately 2300 rows, currently sorted by
name.
I need to sort by Password in the above indicated order.

Anybody have any ideas how his might be done? Or if it's even possible?

Thanks,

Mike- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -