1

I'm trying to sort the output of KiCad automatically generated BOM.

Example would be

R1
R8
R2
R14
R11
R18

If I sort this alphabetical A-Z I get: R1 R11 ... But I would rather have: R1 R2 R8 R11 R14 R18.

Could anyone help me out how to acheive this within Excel? Or do I need a macro for that?

Kind Regards

Sam Protsenko
  • 14,045
  • 4
  • 59
  • 75
Barat
  • 11
  • 3

1 Answers1

1

You could have a second column with a formula:

=Right(A1, len(A1)-1)

Which, when copied down, would give you a list like:

1
11
14
18
2
8

Which you could use to sort. This is assuming that your data always starts with a single alpha character, followed by numbers.

JNevill
  • 46,980
  • 4
  • 38
  • 63