Hello,
I have a column each row of which contains a sequence of one or more codes
separated by a space. In case it will make a difference each code consists of a
letter (ooccasionally 2 letters) followed by a number of up to 3 digits (and
occasionally ends with a letter) eg X1 Aa12 D7a etc.
I
Wow! Thanks i'll look into that and maybe try to adapt it. The strings are of
variable length from 1 to 3 characters. What i came up with (bypassing VLOOKUP
altogether) was
=CONCATENATE (MID ($J$2, FIND(LEFT (A2,1), $J $3),1),IFERROR(MID($J$2, FIND
(MID (A2,2,1), $J $3),1," "),IFERROR (MID ($J
Apologies if this appears twice; im not sure if there was a problem with
sending...
Hello,
I have a column each row of which contains a sequence of one or more codes
separated by a space. In case it will make a difference each code consists of a
letter (ooccasionally 2 letters) followed by a
Just google for "characters sorting order"...you'll have to choose by
yourself...
Je la 11/03/2017 18:58, Gary Collins skribis :
Hello
Id like to know if there is a character, preferably some sort of discreet
punctuation mark, that will come *after* z in the sort order when using natural
Hello
Id like to know if there is a character, preferably some sort of discreet
punctuation mark, that will come *after* z in the sort order when using natural
sort. My problem is that i have some codes beginning Aa which really speaking
should come after Z. As a number of up to 3 digits
At 17:58 11/03/2017 +, Gary Collins wrote:
I'd like to know if there is a character, preferably some sort of
discrete punctuation mark, that will come *after* z in the sort
order when using natural sort. My problem is that i have some codes
beginning Aa which really speaking should come
At 15:45 11/03/2017 +, Gary Collins wrote:
I have a column each row of which contains a sequence of one or more
codes separated by a space. In case it will make a difference each
code consists of a letter (occasionally 2 letters) followed by a
number of up to 3 digits (and occasionally