View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default 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?