I have given a formula that gives the specific cell data into the text i.e
="text "&AB4&" text" now my problem is that AB4 is the percentage it gives
me 7 or 8 digits after the point but don't need any digit after or maximum 2.

"Junaid" wrote:
I have given a formula that gives the specific
cell data into the text i.e ="text "&AB4&" text"
now my problem is that AB4 is the percentage
it gives me 7 or 8 digits after the point but don't
need any digit after or maximum 2.

I'm not exactly sure what you want, but I hope you can make use of the
following:

="text " & TEXT(AB4,"0.00%") & " text"