Skip to main content
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
  3.7K Visits
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.


I am using Kutools Plus > Worksheet > Split Data

The result ends up looking like


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.
1 year ago
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.

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