software

I have a group of four-digit extensions listed in a spreadsheet and I
need to add an area code and prefix to each. Is there a way to add that
to each cell without editing each cell?

Thanks--
t2true
------------------------------------------------------------------------
t2true's Profile: www.excelforum.com/member.php...foamp;userid=3877
View this thread: www.excelforum.com/showthread...hreadid=529294Insert a quot;helperquot; column and enter this formula:
=quot;(123) 456-quot;amp;A1
....where A1 holds the extension. Copy that formula, and paste for the
rest of the extensions.See previous posting by Kevin.

quot;t2truequot; wrote:

gt;
gt; I have a group of four-digit extensions listed in a spreadsheet and I
gt; need to add an area code and prefix to each. Is there a way to add that
gt; to each cell without editing each cell?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; t2true
gt; ------------------------------------------------------------------------
gt; t2true's Profile: www.excelforum.com/member.php...foamp;userid=3877
gt; View this thread: www.excelforum.com/showthread...hreadid=529294
gt;
gt;


Hi

You can write a formula using the quot;amp;quot; operator (string operator), the
get the the new values in a different column and finally copy--gt;value
the results to the original column.
For example: in column A you have quot;1234quot;, you need to add quot;-ABCquot;;
in column B enter the formula A1amp;quot;-ABCquot;. The resulta will be
quot;1234-ABCquot;. Now Ctrl C B1 and Paste---gt;Value to A1.--
jordun------------------------------------------------------------------------
jordun's Profile: www.excelforum.com/member.php...oamp;userid=33118
View this thread: www.excelforum.com/showthread...hreadid=529347