Stripping data

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

How best to achieve this, please:

data is of the type 999 102A and is the only entry
in a cell.

I would like to strip the data to end up with 2 options,
either 102A or just A.

Regards.
 
Hi Stuart
to get '102A' try
=RIGHT(A1,4)

to get 'A'
=RIGHT(A1,1)

but I'm sure I have missed something :-)
Frank
 
Thanks for that.
My best guess about the data is that 999 is some sort of
Job reference, 102 is a page number, and A is an item
reference.
999 could equally be 9 or 99, but since there is a space
before the page/item reference, then I could remove the
99whatever reference using Split... so I'd then be left
with 102A which would be the 1st solution.

But 102A could equally be 1A, 15A or 999A, and I
will not know which. As best I can tell, though, is that
it will always be a sequence of numbers ending in a
single capital letter.......how do I isolate that letter?

Regards and thanks

Frank Kabel said:
Hi Stuart
to get '102A' try
=RIGHT(A1,4)

to get 'A'
=RIGHT(A1,1)

but I'm sure I have missed something :-)
Frank
Click to expand...
 
Right(split("999 102A"," ")(1),1)

From the immediate window:

? Right(split("999 102A"," ")(1),1)
A

? Right(split("9 15A"," ")(1),1)
A


--
Regards,
Tom Ogilvy

Stuart said:
Thanks for that.
My best guess about the data is that 999 is some sort of
Job reference, 102 is a page number, and A is an item
reference.
999 could equally be 9 or 99, but since there is a space
before the page/item reference, then I could remove the
99whatever reference using Split... so I'd then be left
with 102A which would be the 1st solution.

But 102A could equally be 1A, 15A or 999A, and I
will not know which. As best I can tell, though, is that
it will always be a sequence of numbers ending in a
single capital letter.......how do I isolate that letter?

Regards and thanks
Click to expand...
 
Many thanks to you both.

Apologies for the delay, but my ISP was in difficulty.....
(again).

Regards.
 
Back
Top