Combining Two cells the delete

[jbk]

Hello, attached is an example of what I would like to accomplish.

In this example I have Cell "A's" data being combined with Cell "B's" data for a result in "C".

I would then like to delete Cell A and B and retain combined data in "C". How is this possible

[martindwilson]

just copy paste back over itself column c as paste /special/ values then clear or delete cols a and b

[jbk]

Thanks Maritin...

Could a marco be designed that would combine Data in "A" and "B" for a result in "C" then delete A&B with results left in "C"?

[martindwilson]

well heres a dirty way but it should work

Please Login or Register  to view this content.

[jbk]

Thank you... How does one but a space between the values of "A" & "B" that are combined in "C"

[martindwilson]

like this

Please Login or Register  to view this content.

the other extra application bits stop screen flicker as the macro runs

[jbk]

Thank you...