How do I enter a prefix number to a colum of numbers

[Newbee101l]

I need to enter a prefix number (BC5) to each number in a colum of numbers.

 

[BenjieLop]

I need to enter a prefix number (BC5) to each number in a colum o
numbers.

Assuming that your numbers are in Column A and starting at Cell A1
enter this formula in Cell B1

="BC5"&A1

and copy down until the cell opposite the last number in Column A.

Is this the solution that you are looking for

 

[newbee101]

You the Man Benjie. Thanks a couple of thousand, literally.

 

[BenjieLop]

Thanks for the feedback ... I am just glad that I can help.

Regards.