Mapping the data & the getting output

Originally Posted by martindwilson

try
=LEFT(A1,FIND(" ",A1))&" (4904 "&MID(A1,SEARCH("A????B",A1),6)&")"
or to get rid of odd space at end
=LEFT(A1,FIND(" ",A1))&" (4904 "&SUBSTITUTE(MID(A1,SEARCH("A????B",A1),6)&")"," ","")

Dear Martin

Thanks a lot

It works fine.

Many Thanks
Balaji