Hello Group -
I have a very long Excel Formula I am trying to truncate after a given number of characters. I would like to delete everything that comes after View#. Is there a way to do this efficiently without having to go into each cell and delete manually? Thanks.
=HsGetValue("Scenario#"&D$2&";Year#"&D$5&";Period#"&$B$6&";View#"&$B$8&";Entity#"&$A26&";Value#"&$B$7&";Account#"&D$3&";XXX#"&$B$9&";Custom1#"&$B$10&";Custom2#"&$B$11&";Custom3#"&$B$12&";Custom4#"&$B$13&"")/1000
I have a very long Excel Formula I am trying to truncate after a given number of characters. I would like to delete everything that comes after View#. Is there a way to do this efficiently without having to go into each cell and delete manually? Thanks.
=HsGetValue("Scenario#"&D$2&";Year#"&D$5&";Period#"&$B$6&";View#"&$B$8&";Entity#"&$A26&";Value#"&$B$7&";Account#"&D$3&";XXX#"&$B$9&";Custom1#"&$B$10&";Custom2#"&$B$11&";Custom3#"&$B$12&";Custom4#"&$B$13&"")/1000