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.



[TABLE="width: 103"]
<colgroup><col></colgroup><tbody>[TR]
[TD]SG17424
[/TD]
[/TR]
[TR]
[TD]17324
[/TD]
[/TR]
[TR]
[TD]17224
[/TD]
[/TR]
[TR]
[TD]17024
.
.
.
[/TD]
[/TR]
</tbody>[/TABLE]
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