• how do I delete data in a cell without deleting formula?

    From ecomreed05@gmail.com@21:1/5 to All on Thu Jun 18 14:21:42 2020
    I’m replying to a post from 4 years ago, replying to a post from 5 years ago, about a post from 12 years ago...

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Auric__@21:1/5 to All on Fri Jun 19 22:07:27 2020
    ecomreed05 wrote:

    I=E2=80=99m replying to a post from 4 years ago, replying to a post from
    5 = years ago, about a post from 12 years ago...

    ...with absolutely no context whatsoever. The only reason this even caught my attention is because it references my post in this thread. You idiots are a waste of oxygen.

    --
    This is the most disturbing conversation I've ever had.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Michael Kilts@21:1/5 to All on Sun Sep 20 12:06:00 2020
    I've just Subscribed to this thread, to watch it continually unfold for the next 20+ years.

    Please, continue.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Digital Ego@21:1/5 to Michael Kilts on Thu Jul 8 06:51:20 2021
    On Sunday, September 20, 2020 at 10:06:03 PM UTC+3, Michael Kilts wrote:
    I've just Subscribed to this thread, to watch it continually unfold for the next 20+ years.

    Please, continue.

    I like how things are heating up here. Truly insane!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From =?UTF-8?Q?Beltr=C3=A1n_Gimenez=2DZa@21:1/5 to All on Tue Jun 7 10:31:17 2022
    El jueves, 8 de julio de 2021 a las 15:51:22 UTC+2, Digital Ego escribió:
    On Sunday, September 20, 2020 at 10:06:03 PM UTC+3, Michael Kilts wrote:
    I've just Subscribed to this thread, to watch it continually unfold for the next 20+ years.

    Please, continue.
    I like how things are heating up here. Truly insane!

    Watch as I reply to your 1 year old post replying to a couple of posts from 2 years ago replying to a post from 6 years ago, replying to a post from 7 years ago, about a 14 year old post.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Auric__@21:1/5 to All on Tue Jun 7 18:13:50 2022
    =?UTF-8?Q?Beltr=C3=A1n_Gimenez=2DZapio?= wrote:

    El jueves, 8 de julio de 2021 a las 15:51:22 UTC+2, Digital Ego
    escribió:
    On Sunday, September 20, 2020 at 10:06:03 PM UTC+3, Michael Kilts
    wrote:

    I've just Subscribed to this thread, to watch it continually unfold
    for the next 20+ years.

    Please, continue.
    I like how things are heating up here. Truly insane!

    Watch as I reply to your 1 year old post replying to a couple of posts
    from 2 years ago replying to a post from 6 years ago, replying to a post
    from 7 years ago, about a 14 year old post.

    You are all a bunch of idiots.

    --
    There must be more to life than standing
    around wondering if there's more to life.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From David Michael@21:1/5 to All on Wed Aug 17 08:44:58 2022
    bump

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Auric__@21:1/5 to David Michael on Wed Aug 17 17:19:35 2022
    David Michael wrote:

    bump

    This isn't 4chan. The thread won't get deleted if people stop posting.

    Fucking Google groupies.

    --
    more like free insurance than free rental

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Philip Herlihy@21:1/5 to All on Thu Aug 18 11:28:43 2022
    In article <dfbfde2b-5bba-475b-b709-a23191a2288fn@googlegroups.com>, David Michael wrote...

    bump

    I can't make any sense of your question. Just be selective in what you delete? What situation prompts that question?

    Trying to unpack: I infer that you have data (constants?) in a cell which contains a formula. If so, try moving the constants to a dedicated worksheet, and name the ranges. Simple example: I have a spreadsheet which tracks my alcohol consumption units (medical necessity, sadly). I have a named range called "PINT", and I refer to it in a cell as '=PINT'. The named range PINT contains the value 568. There are other ranges called 'BOTTLE' and 'HALFBOTTLE'. If someone in the USA wanted to use my spreadsheet, they could edit PINT to 473.

    Throughout IT, it's beneficial to keep raw data independent from operations which derive from that data, and similarly from formatting markup. The benefits of this increase with the scale of the project.

    --

    Phil, London

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Amman Pasha@21:1/5 to Philip Herlihy on Tue Feb 21 15:38:09 2023
    On Thursday, August 18, 2022 at 3:28:44 PM UTC+5, Philip Herlihy wrote:
    In article <dfbfde2b-5bba-475b...@googlegroups.com>, David
    Michael wrote...

    bump

    I can't make any sense of your question. Just be selective in what you delete?
    What situation prompts that question?

    Trying to unpack: I infer that you have data (constants?) in a cell which contains a formula. If so, try moving the constants to a dedicated worksheet, and name the ranges. Simple example: I have a spreadsheet which tracks my alcohol consumption units (medical necessity, sadly). I have a named range called "PINT", and I refer to it in a cell as '=PINT'. The named range PINT contains the value 568. There are other ranges called 'BOTTLE' and 'HALFBOTTLE'. If someone in the USA wanted to use my spreadsheet, they could edit PINT to 473.

    Throughout IT, it's beneficial to keep raw data independent from operations which derive from that data, and similarly from formatting markup. The benefits of this increase with the scale of the project.

    --

    Phil, London
    happy new year guys

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Charles Jestice@21:1/5 to Amman Pasha on Tue Mar 14 13:40:30 2023
    On Tuesday, February 21, 2023 at 5:38:11 PM UTC-6, Amman Pasha wrote:
    On Thursday, August 18, 2022 at 3:28:44 PM UTC+5, Philip Herlihy wrote:
    In article <dfbfde2b-5bba-475b...@googlegroups.com>, David
    Michael wrote...

    bump

    I can't make any sense of your question. Just be selective in what you delete?
    What situation prompts that question?

    Trying to unpack: I infer that you have data (constants?) in a cell which contains a formula. If so, try moving the constants to a dedicated worksheet,
    and name the ranges. Simple example: I have a spreadsheet which tracks my alcohol consumption units (medical necessity, sadly). I have a named range called "PINT", and I refer to it in a cell as '=PINT'. The named range PINT
    contains the value 568. There are other ranges called 'BOTTLE' and 'HALFBOTTLE'. If someone in the USA wanted to use my spreadsheet, they could
    edit PINT to 473.

    Throughout IT, it's beneficial to keep raw data independent from operations
    which derive from that data, and similarly from formatting markup. The benefits of this increase with the scale of the project.

    --

    Phil, London
    happy new year guys
    No one has really answered the question either.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Netstar WebApp@21:1/5 to Charles Jestice on Wed Mar 15 18:00:27 2023
    On Wednesday, March 15, 2023 at 4:40:35 AM UTC+8, Charles Jestice wrote:
    On Tuesday, February 21, 2023 at 5:38:11 PM UTC-6, Amman Pasha wrote:
    On Thursday, August 18, 2022 at 3:28:44 PM UTC+5, Philip Herlihy wrote:
    In article <dfbfde2b-5bba-475b...@googlegroups.com>, David
    Michael wrote...

    bump

    I can't make any sense of your question. Just be selective in what you delete?
    What situation prompts that question?

    Trying to unpack: I infer that you have data (constants?) in a cell which
    contains a formula. If so, try moving the constants to a dedicated worksheet,
    and name the ranges. Simple example: I have a spreadsheet which tracks my
    alcohol consumption units (medical necessity, sadly). I have a named range
    called "PINT", and I refer to it in a cell as '=PINT'. The named range PINT
    contains the value 568. There are other ranges called 'BOTTLE' and 'HALFBOTTLE'. If someone in the USA wanted to use my spreadsheet, they could
    edit PINT to 473.

    Throughout IT, it's beneficial to keep raw data independent from operations
    which derive from that data, and similarly from formatting markup. The benefits of this increase with the scale of the project.

    --

    Phil, London
    happy new year guys
    No one has really answered the question either.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Amy Voss@21:1/5 to All on Thu Mar 16 16:51:19 2023
    Is there still no solution after 15 years? It would really be great if there was...

    I have a large spreadsheet I need to update without losing the formulas.

    Carry on peeps... this is getting spicy!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Michael Kilts@21:1/5 to Michael Kilts on Fri Mar 17 10:44:04 2023
    On Sunday, September 20, 2020 at 1:06:03 PM UTC-6, Michael Kilts wrote:
    I've just Subscribed to this thread, to watch it continually unfold for the next 20+ years.

    Please, continue.


    send help - this has befuddled mathematicians for centuries

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Elizabeth Kennedy Bayer@21:1/5 to All on Tue Apr 11 17:47:43 2023
    I've given up on finding meaning in my life and am now copying and pasting as formulas only 🤷

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Owen@21:1/5 to All on Thu Jun 15 23:07:33 2023
    On Saturday, August 1, 2015 at 1:59:57 AM UTC+9, Auric__ wrote:
    mattsteel101 wrote:

    On Sunday, April 20, 2008 at 11:07:25 PM UTC+1, David Biddulph wrote:
    A cell contains either formula or data. It can't contain both.

    That is rubbish David

    You're replying to a post from 7 years ago.

    --
    I look at my life and it just seems so depressing that I'm
    not sure if I was born or if Morrissey sang me into existence.

    Doesn't make it any less true.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Logann Halloran (Only Forward Fitne@21:1/5 to Owen on Fri Jun 23 12:59:39 2023
    On Friday, June 16, 2023 at 2:07:35 AM UTC-4, Owen wrote:
    On Saturday, August 1, 2015 at 1:59:57 AM UTC+9, Auric__ wrote:
    mattsteel101 wrote:

    On Sunday, April 20, 2008 at 11:07:25 PM UTC+1, David Biddulph wrote:
    A cell contains either formula or data. It can't contain both.

    That is rubbish David

    You're replying to a post from 7 years ago.

    --
    I look at my life and it just seems so depressing that I'm
    not sure if I was born or if Morrissey sang me into existence.
    Doesn't make it any less true.
    Feel like there needs to be separate cells for the data and formulas. Would =IF Functions would have worked? =IF(A3>4, sum(A2+A4+A5), 0). Happy to be hear. Look forward to the next 15 years.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)