Changing absolute cell references

Dear Experts:

I got thousands of records where I have to concatenate two cells as follows

The Formula in D5 is as follows:

Copying it down all the way does not any good since I need to change the absolute references as soon as the number in column E (green data records) change.

Any idea how I can get his done either by a formula or an Excel Macro?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

I have attached the sample file for your convenience.

Andreas HermleTeam leaderAsked:
Who is Participating?
FlysterConnect With a Mentor Commented:
See if this formula works for you:


Use Special Paste - Formula

Andreas HermleTeam leaderAuthor Commented:
Hi Flyster,

this is great, I am so happy with it. It saves me many hours of tedious and stupid work :-)

Thank you very much for your professional help. I really highly appreciate it.

Regards, Andreas and have a nice day.
Thank you Andreas. I'm glad I could assist!!
All Courses

From novice to tech pro — start learning today.