Following is the data copied into excel.

Teirb FT5567 xxx gghgh ytytyty r.

First I find and replace all of the Teirb.

Second I trim the spaces (ex. =trim(a1).

Third I only the 6 left characters (ex. =left(a1,6).

My result I'm looking for is FT5567.

Is there a way to combine the replace, trim, and left formula into one?
Or at least the trim and left into one formula?


Thanks,

Jack