TRIM formula

[bflan0524]

hello, i know how to remove characters from the beginning and end of a # but how do you start at a specific character

for example if in A1 it shows 880881005697700010000000018 and i want to remove 10 characters after the first four how would i do that

ty

 

[Joe4]

So, if you just want to remove characters 5-14, then you could use a formula like this (for an entry in cell A1):

=LEFT(A1,4)&MID(A1,15,LEN(A1))

 

[Fluff]

Another option

=REPLACE(A1,5,10,"")