Excel (format cells) - HELP

A

ampd11

I have a series of letters followed by a series of numbers in a
spreadsheet. I need to add a letter at the end. Example BBB123 - I need
it to look like BBB123A. Can this be done? If so, how? Thanks.
 
B

Bernard Rey

ampd11 said:
I have a series of letters followed by a series of numbers in a
spreadsheet. I need to add a letter at the end. Example BBB123 - I need
it to look like BBB123A. Can this be done? If so, how? Thanks.
Click to expand...

One way:

Let's say you have "BBB123" in cell A2. In a free cell on your worksheet,
let's say H2, type:
=A2 & "A"
In cell H2 you can now see "BBB123A". Copy this cell down as much as needed.
Now, select the whole series of cells in col H and copy the lot. Select cell
A2 and, from the "Edit" menu grab the "Paste Special..." item. Click the
"Values" radio button and then the "OK" button. The cells in column A should
now correspond to what you wanted. You can clear the cells in column H and
you're through.
 
Top