Formula Query

G

Guest

I was wondering if there is a formula to replace the first four digits of any
given sequence of numbers ie 1234567 needs to be replaced with xxxx567.the
length of the numbers are varied ie the number could also be 12345 in which
case it needs to be replaced with xxxx5.

Thanks
 
D

David Biddulph

davids said:
I was wondering if there is a formula to replace the first four digits of
any
given sequence of numbers ie 1234567 needs to be replaced with xxxx567.the
length of the numbers are varied ie the number could also be 12345 in
which
case it needs to be replaced with xxxx5.
Click to expand...

="xxxx"&RIGHT(A1,LEN(A1)-4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replace numbers with X 5
working with length formula 3
Extracting 7 digit number from alphanumeric string 10
Need to remove hyphen in group of #s 2
Access Access 2007 Delete Part of Text 0
insert a dash 5
select a range in a column 4
Formula function(s) to do this? Or is it a formula at all? 4

Top