concatenate then delete original data

[Colin Weir]

Hi there

I recently found the concatenate function which is really helpful. I
was wanting to know if there is a way I can perform this function and
then be able to delete the original data and keep the combined data?
I managed to do this in a CSV file by saving and closing, however this
does not seem to work in a normal xlsx file.

Any suggestions would be appreciated.

Thanks

Colin

 

[Dave Peterson]

After you concatenate the data, you can convert it to values:

select the range
Copy|paste special|values

Then delete the original data.

If this doesn't help, maybe you can explain how it fails for you.

 

[Zaidy036]

Hi there

I recently found the concatenate function which is really helpful. I
was wanting to know if there is a way I can perform this function and
then be able to delete the original data and keep the combined data?
I managed to do this in a CSV file by saving and closing, however this
does not seem to work in a normal xlsx file.

Any suggestions would be appreciated.

Thanks

Colin

free ASAP Utilities has this function under "Formulas"
see http://www.asap-utilities.com/