Putting characters in front of numbers ...

[Morty07]

Hi, I want to put characters in front of numbers in a cell.

The first cell are as you can see "SG17424", but I have to put characters in front of the rest of the cells. It is around 8200 products.

SG17424

17324

17224

17024 . . .

<colgroup><col></colgroup><tbody>
</tbody>

Morty07

 

[Special-K99]

in B1
=IF(ISNUMBER(A1),"SG"&A1,A1)
and copy down the column

copy column B
paste values over the top of column B
delete column A

 

[Morty07]

Thankz Special-K99, it worked. Have a nice day