Merge data from 2 cells

[Enzo137]

can any one help me.
I have 2 columns of data and need to merge the data into 1 cell.
For instance, column A contains data like "Extra Strength TPE gloves" and column B contains data like "medium".
I need a formula or VBA that merges the data like this, "Extra Strength TPE medium gloves".
The data contained in column B must be inserted after the TPE in column A.

Thanks

[bebo021999]

Try this in C1:
=LEFT(A1,SEARCH("TPE",A1,1)+3)&B1&MID(A1,SEARCH("TPE",A1,1)+3,256)

[Enzo137]

Perfect, thanks for your help