Append characters in all the lines in each row

[exceltry1]

Hi ,
I have a spreadsheet where I have a column of names_1 like this...

sl.no. names_1
1 abcd
xyz
2 qjrno
3 sybt
zehf
cvsy
4 udprh

I need to create a new column called names_2 and copy the contents from names_1 column appending '.doc'
The result in column names_2 should exactly look like this,
sl.no. names_1
1 abcd.doc
xyz.doc
2 qjrno.doc
3 sybt.doc
zehf.doc
cvsy.doc
4 udprh.doc


I tried this response from oldchippy posted earlier,

"with your data in column A, put this in B1 and auto-fill down

=A1&".txt"

then copy column B, paste special > values over column A, then delete column B"
and the reponse from dominicb posted earlier,
" =CONCATENATE(A1,".txt") and copying down "

But after trying both the methods, i get the below results,

sl.no. names_1
1 abcd
xyz.doc
2 qjrno.doc
3 sybt
zehf
cvsy.doc
4 udprh.doc

Only the last line in each row is getting appended with '.doc' and not every lines in each row.

Could someone please let me know how to make all the lines in each row to be appended with '.doc' extension


Thanks

[royUK]

Welcome to the Forum. Please read the Forum Rules & don't use unnecessary words in your Titles, this makes the Forum Search Engine more efficient.

Try

=A1 & ".doc"

Place it in B! & copy down.

[exceltry1]

Hi,
Thanks for you reply, I tried using =A1 & ".doc" , but the result was as below,

sl.no. names_1
1 abcd
xyz.doc
2 qjrno.doc
3 sybt
zehf
cvsy.doc
4 udprh.doc


But i need the result to be shown as below,

sl.no. names_1
1 abcd.doc
xyz.doc
2 qjrno.doc
3 sybt.doc
zehf.doc
cvsy.doc
4 udprh.doc

i.e., '.doc' extension should be appended in all the lines in each row.

Thanks

[royUK]

Can you attach an example so that we can see what you mean.?