Solved Min Max with Alpha Characters Excel

February 16, 2017 at 14:58:51
Specs: Windows 7
I am looking to combine 2 numbers based off the min then the max. I started with =min(b2;c2)&max(b2;c2) But now I have alpha characters in the mix

Example:
B C
9000 925E
925A 9231
9620 9300

Desired results

A
9000925E
9231925A
93009620


See More: Min Max with Alpha Characters Excel

Reply ↓  Report •

#1
February 16, 2017 at 17:36:01
✔ Best Answer
First, a posting tip:

Please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

As far as your question, does this work for you?

=IF(B2<C2,B2&C2,C2&B2)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question