Loading

concatenate then delete original data

Report thread as spam

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

This question was started by Colin Weir 2 years ago

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.

>

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

This response was posted by Dave Peterson 2 years ago

In article 1bc957df-88d9-42f4-99ba-3a9a3fb51f69@v11g2000prb.googlegroups.com, Colin Weir at colin.weir@blueyonder.co.uk says... >

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/ -- Zaidy

This response was posted by Zaidy036 2 years ago

Other excel threads