Excel Formula -

[jpryal]

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

 

[mikerickson]

Does "delete everything that comes after View#" mean that you want

=HsGetValue("Scenario#"&D$2&";Year#"&D$5&";Period#"&$B$6&";View#")

or
=HsGetValue("Scenario#"&D$2&";Year#"&D$5&";Period#"&$B$6&";View#")/1000

 

[jpryal]

The second option

=HsGetValue("Scenario#"&D$2&";Year#"&D$5&";Period#"&$B$6&";View#")/1000

 

[mikerickson]

Use search and replace

Find: View#"*)
Replace View#")

 

[jpryal]

Marvelous. Thank you so much. It worked.