Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep last 4 characters of value
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep last 4 characters of value
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep last 4 characters of value
=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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep last 4 characters of value
On Thu, 15 Nov 2007 03:26:00 -0800, 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 B1: =RIGHT(A1,4) or =MOD(A1,10000) C1: =LEFT(A1,LEN(A1)-4) or =INT(A1/10000) The TEXT formula will return an error if LEN(A1) is not 4; the Math formula will return a "0" in that case. It's not clear what result you want in those instances. --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep last 4 characters of value
Not sure if I have understood this right but you could try this:
=LEFT(A1, LEN(A1)-4) This will remove the last 4 characters from your cell "ArcticWolf" wrote: =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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many characters in a box..? | Excel Worksheet Functions | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
sum of characters | Excel Discussion (Misc queries) | |||
Hex Characters | Excel Worksheet Functions |