Hi there Everyone! I have the following problem. I have an excel sheet where I gather information about companies. There are two columns involved in my problem. Column "D" and column "E". In column "D" I put the country code (example: DE for Germany, GB for England and so on..) In column "E" I put a number (for example: 45786521). What I would like Excel to do is to autoinsert the value of the column "D" before the numbers I have written in column "E". For example if in Row 12 column "D" is GB. And then I write the number 555888777 in column "E", then after the number is written and I hit Enter I would like column "E" to look this way: GB555888777. So the GB (value of the column "D") is inserted at the beginnig of the number I just wrote in column "E". How can that be done?
P.S.:I know that there is a possibility to add the values of these two columns in another column, but as there are far too many columns in the worksheet I would not like to add an extra column just for this.
Thank you in advance for your help, and have a nice weekend!
Bookmarks