concatenate then delete original data

  • Thread starter Thread starter Colin Weir
  • Start date Start date
C

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
 
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.
 
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
Click to expand...

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