Append value to cell or cells

T

t2true

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
 
D

Dave O

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

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