Delete every thing before # sign

Yes both are working to my end..


see there is little change in Ali`s formula its not F8 (which will work only if len of "KD-0219" is 7) and mine will work for any string

Formula:

=LEFT(A1,8)&RIGHT(A1,LEN(A1)-FIND("#",A1)+1)

see attached file