Formula to use first 3 and last 4 characters of a word

[FlyingJob83]

So I am trying to format a list of data given to me. Example below

ABC123456789

I am fairly new to excel, but I am trying to figure out how to combine or make a formula to format the data to something like below.

ABCXXXXX6789

I need the digits in between X'd out or *'d out. But I need the formula to include the first 3 and last 4 characters. I figure it has something to do with LEFT, RIGHT, and CONCATENATE formulas, but I can't figure this out. Any help is greatly appreciated!

[Pete_UK]

Assuming that is in A1, you could use this formula (say in B1):

=LEFT(A1,3)&REPT("X",LEN(A1)-7)&RIGHT(A1,4)

The & symbol is the concatenation operator (for joining strings) - quicker to type than the function.

Hope this helps.

Pete

[Moo the Dog]

If ABC12345679 is in cell A1, you could use this: =LEFT(A1,3)&"XXXXX"&RIGHT(A1,4)

- Moo

[Teethless mama]

=replace(a1,4,5,rept("x",5))