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

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?

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

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

"Newbs18" wrote in message
...
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?

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

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


--
ShaunM
------------------------------------------------------------------------
ShaunM's Profile: http://www.excelforum.com/member.php...o&userid=18610
View this thread: http://www.excelforum.com/showthread...hreadid=483368