Change formula to value in excel

Help
1

Hi, I have formulas in my certain cells in the excel. How can I change it to value?

Any suggestions?

Thank you xoxo

2

Hello @sangasangasanga

You can use Write Cell Activitie

3

Hi, I am writing the formula using write cell activity also. Could you pls elaborate?

4

@sangasangasanga

Maybe I didn’t understand your question.

Do you need change the value in cell to which type of value?

5

There is a formula in the cell
image

I would like to change it to value like below
image

6

You can pass the value in Write Cell Activitie this way “Printing Services” or "=Printing Services’’

7

If I understood what you are saying correctly, I wouldn’t know the value of the formula for each cell as it changes every time

8

hey @sangasangasanga , did you get the solution for this?

9

nope

10

Please refer this link :

https://www.rondebruin.nl/win/s9/win015.htm

I have used the Vba code and invoked it in my workflow.

11

Hi @sangasangasanga

  1. Use read cell activity from workbook and read the perticular cell value.
  2. Keep the value in a temporary veriable.
  3. Use write range activity and pass the temporary variable in it.

I just tried above steps and its working fine.
Let me know the feedback.

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.