Keep last 4 characters of value
Thanks for the swift reply Stephen - works perfect.
"Stephen" wrote:
=LEFT(A1,LEN(A1)-4)
"ArcticWolf" wrote in message
...
=right(a1,4) returns the last 4 digits but how do I get the text
preceeding
the last 4 please?
"ArcticWolf" wrote:
Hi,
I need to remove the last 4 characters of value (b1).
I also need to remove all preceeding characters except the last 4
characters
of a value (c1)
Each value is of a different lenght.
IE
a1= 1234567890 (original value)
b1=123456
c1=7890
Thanks in advance,
AW
|