Excel Formula

[RExcelSearch]

I have cell J4 IGGA-01BAF2101PD0324 I would like create a formula that would that change to AP-PYMT-BAF2101-X , where X will represent a number.
The information will be in one cell.

 

[Kerryx]

Based on what you said

Book1
	B	C
2	IGGA-01BAF2101PD0324	AP-PYMT-BAF2101-X
Sheet1

Cell Formulas
Range	Formula
C2	C2	="AP-PYMT-"&MID(B2,8,7)&"-X"