Creating text combinations given two base texts.

Please note the forum rules concerning meaningful thread titles. Since this is your first post I have edited it for you

original title: Excel 2007 query - Please help!

Hi folks,

Hope you are well.

I have an Excel 2007 query.

Scenario:
I have a list of first name and surname listed in columns A17, A18, A19, etc.

I copy the individual first name and surname from cell A17 and paste it into cell A1. Thereafter columns C1-12 get updated with different combination of names as follows (using concatenate):

Alex Bailey
Bailey Alex
ABailey
BaileyA
Alex
Bailey
...
...

Instead of copying individual first/surname from cell A17 and then pasting it into column A1, B1 respectively, is there a way so that when column A17 is clicked columns C1 to C12 get updated automatically, then when column C18 is clicked, columns C1 to C12 are overwritten with the new first and surname.

I have attached a sample spreadsheet.

Hi,

See attached,

Rgds