Hello Forum,

Excuse me for asking the same question. I submitted on the Excel 2010 forum
in error.

I have several columns of data. I need to ensure that a part of one column
ends up as a part of another. Allow me to set an example...

Column 'A' has a cell entry of e.g. A123 (or any single letter and 3
numbers). I need to make sure that this combination e.g A123 is inserted in
the same part of the next column with the following format...

x_xxxxx-A123xxxxxx

Hope this makes sense.

Thank you for you help.

Dave Tee