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.

On 04/14/2011 05:53, Colin Weir wrote:
> 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

In article <1bc957df-88d9-42f4-99ba-(E-Mail Removed)>,
Colin Weir at (E-Mail Removed) 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