ExcelBanter - Formula Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Query (https://www.excelbanter.com/excel-discussion-misc-queries/77622-formula-query.html)

davids

Formula Query

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

David Biddulph

Formula Query

"davids" wrote in message
...
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.

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

All times are GMT +1. The time now is 03:49 PM.