I need to remove or hide the first 5 digits in a string of 9 numbers for a
column. Any easy way to do this?
I need to remove or hide the first 5 digits in a string of 9 numbers for a
column. Any easy way to do this?
If you need it to be a number try
=value(right(A1,4))
if it can be text don't use the value()
"RNeducator" wrote:
> I need to remove or hide the first 5 digits in a string of 9 numbers for a
> column. Any easy way to do this?
Hello,
=--MID(A1,6,LEN(A1)-5)
to get result as a number
=MID(A1,6,LEN(A1)-5)
to get it as a string
If you are sure that it's a number and 9 digits you can take
=MOD(A1,10000)
or
=--RIGHT(A1,4)
HTH,
Bernd
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks