Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 18 November 2022
  1 Replies
  1.3K Visits
0
Votes
Undo
Wanted to throw this out here in case I'm missing something. Use of formulas (especially when calculating from another table). Here's an example (data from W3Schools). Before and after spreadsheets are attached.

image_2022-11-17_112539374.png

I am using Kutools Plus > Worksheet > Split Data

The result ends up looking like

image_2022-11-17_112635298.png

My existing workaround is

  1. Select the entire sheet
  2. Copy
  3. Paste (values)
  4. Kutools Plus > Worksheet > Split Data


Not sure if this can be accounted for when splitting in the future. At the very least it would be nice to have an option to convert cells into values before splitting the data.
2 months ago
·
#3217
0
Votes
Undo
Hi there,

Thanks for you feedback, And we have included this option in our next version. :D

Make sure that you have subscribed our website, so that you will receive the information about the new Kutools for Excel when it's released in the near future.

Amanda
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL