add default txt in a cell(s) without changing he original

[phynfan]

example:
Col A
row 1: server01
row 2: server02
row 3: server 03 etc
I need to add FQDN to each of those cells without changing orignal text;

Col A
row 1: server01.abc.com
row 2: server02.abc.com etc
Thanks for the help

 

[vds1]

Welcome to MrExcel.com


You can have test column "B" and insert the below formula


=A1 & ".abc.com"


Later you can copy paste to column A and delete column B

 

[phynfan]

excellent. Worked like a charm
Thanks.