RE: Append value to cell or cells

[Toppers]

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
>
>

[jordun]

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.