How do you remove specific digits from a cell

[luisvanegas]

Hello, I have a list of numbers (formated as text) that are 12 digits long. I need to remove the 3 digits prior to the last one (or the 9,10, and 11 digit). Is there a formula for that?

For example, my number is: [TABLE="width: 164"]
<tbody>[TR]
[TD="class: xl63, width: 164"]120184160013
I need it to be:
120184163[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Welcome to the board

Try

=REPLACE(A1,9,3,"")

 

[luisvanegas]

Welcome to the board

Try

=REPLACE(A1,9,3,"")

Thank you evry much.. It worked !!

 

[Jonmo1]

You're welcome.

 

[Artpop12]

You're welcome.

Do you know how to do this thing in Excell!
Here is my thread:

My thread: A chart that is updated per hour

No one seems to know how to do it :/