Try this:

Use or insert a blank column somewhere then type:

="AB"&A1
copy down as far as needed, then copy the column and paste over the original
column (Paste Special - Values) then delete the helper column.

Note: it's always a good idea to save your data before trying anything new.

HTH
JG



"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.