Combining contents of two cells into a new cell and then copying result down the entire column.

[sterjohn]

Can someone please help?

I have a column of various phone numbers in Col D which I need to combine with additional text found in Col F.
I can merge the contents of two cells using; =D1&F1 but when I try to copy this down the destination Column (E), it only copies the numbers from
Col D and not the added text in Col F.
Not sure what I am doing wrong?
Any help would be appreciated.
John.S

 

[paulkc]

When you say "copy" I assume you are referring to copying the formula so that E2 would end up being "=D2&F2." I tested this concept and as expected it worked just fine in my test data. My guess is that it has something to do with your specific data. Any chance you could post a sample?

 

[sterjohn]

When you say "copy" I assume you are referring to copying the formula so that E2 would end up being "=D2&F2." I tested this concept and as expected it worked just fine in my test data. My guess is that it has something to do with your specific data. Any chance you could post a sample?

Hi Paul,
thanks for getting back to me..
I need to combine a list of number as in the left column, with the text in the right column to merge as in the center column below.
I would then like to copy this down the center column so all numbers have the same text on the end.
Any help would be much appreciated.
Kind regards,
JS

0457000605

0457000605@e2s.smsbroadcast.com.au

@e2s.smsbroadcast.com.au​

 

[Fluff]

Are you trying to add the text in F1 to every row?

 

[sterjohn]

Hi Fluff,
thanks for your reply, much appreciated..
Yes I am trying to add the text in F1 to every row.
By that I mean, whenever I add a new phone number to column D, I would like the text to automatically be added to the end if this is possible?
Thanks again,
John.S

 

[bebo021999]

Try in E1 then drag down as far as possible:

=IF(D1="","",D1&$F$1

 

[sterjohn]

Thanks bebo021999 !!, great solution, really appreciate your help on this.
Obviously know your way around excel..
Thanks again,
John.S