How can I add a two letter prefix to text in cells?

G

Guest

Hi. I need to add a two letter prefix to a large number of data cells that
currently have text in them w/o overwritting the current data.

For example a column of this text:

106
108
110
202
206

I would need to add the letters "SE" before the numbers. Any quick way to do
that?
 
A

Anne Troy

Format-->Cells, Custom. Type the following into the short box:
"SE"000
Remember, now, that's not the VALUE of the cell. It's just a VIEW of it.
************
Anne Troy
www.OfficeArticles.com
 
S

ShaunM

Hi

In another column use :

=CONCATENATE("SE",A1)

Where A1 is the cell reference that contains the numbers as listed.

Then just fill the formula down.

Regards

Shaun
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For Joey2004 et al. From OP: Re Appending Question 3
How/can I automatically prefix what is already typed in a cell? 1
How to add up letters to equal a number value. 1
Extracting numbers and letters in a single cell to separate cells 1
Text to Columns Letters and Numbers 5
Soritng with text strings prefixed with single quote 2
adding * to text to column 4
Adding a prefix to all numbers in a column. 1

Top