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" wrote in message
...
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" wrote in message
...
Hi Stuart
to get '102A' try
=RIGHT(A1,4)

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

but I'm sure I have missed something :-)
Frank


Stuart wrote:
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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004