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: http://www.excelforum.com/member.php...fo&userid=3877
View this thread: http://www.excelforum.com/showthread...hreadid=529294

Insert a "helper" column and enter this formula:
="(123) 456-"&A1
....where A1 holds the extension. Copy that formula, and paste for the
rest of the extensions.

See previous posting by Kevin.

"t2true" wrote:


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: http://www.excelforum.com/member.php...fo&userid=3877
View this thread: http://www.excelforum.com/showthread...hreadid=529294

Hi

You can write a formula using the "&" operator (string operator), the
get the the new values in a different column and finally copy--value
the results to the original column.
For example: in column A you have "1234", you need to add "-ABC";
in column B enter the formula A1&"-ABC". The resulta will be
"1234-ABC". Now Ctrl+C B1 and Paste---Value to A1.


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=529347