top of page

Write formula to Excel cell correctly

💡 Encountering errors writing the correct formula to Excel using the action “Write to Excel worksheet”? Use “Activate cell in Excel worksheet”, followed by “Send keys” to write the formula instead. Remember to insert the special key {Return} at the end.

Problem Description


The action “Write to Excel worksheet” does not write the correct formula to Excel sometimes.

For example, the following flow results in an incorrect formula, i.e. =TEXTJOIN("",TRUE,IFERROR((MID(A1,@ROW(INDIRECT("1:"&LEN(A1))),1)*1),"")), being written to cell B1.



Notice that an additional “@” has been added to the Excel formula. While this does not result in an error within PAD, the output in Excel is incorrect.



Solution


As a workaround, we will first use the action “Activate cell in Excel worksheet” to activate the cell that we want to write the formula to.



Then, we will use the action “Send keys” to write the formula to Excel. Remember to insert the special key {Return} which you can find under Insert special keys>>Misc>>Enter.



This will allow you to achieve the desired output:



Additional Information


  • Last updated on: 24 Jan 2023

  • Tested version(s): 2.27.177.22340

  • Prerequisites: Excel

  • Dependencies: None

  • Known issues: None

Robotic Process Automation Singapore

CFB Bots is a leading technology service provider in the fast-growing field of Intelligent Automation. We partner with large enterprises in their Digital Transformation journey and help them and their employees thrive in the Future of Work.

NAVIGATE
CONTACT US
STAY CONNECTED

Singapore

CFB Bots Pte Ltd

Registration No.: 201705263H

77 High Street

#05-09, High Street Plaza

Singapore 179433

T: +65 6909 2099

E: enquiries@cfb-bots.com

Malaysia

CFB Bots Sdn Bhd

Registration No.: 202401045826 (1591672-X)

Suite: 33-01, 33rd Floor

Menara Keck Seng

203 Jalan Bukit Bintang

55100 Kuala Lumpur

T: +60 39 388 0352

E: my@cfb-bots.com

Australia

T: +61 2 8880 5998

E: au@cfb-bots.com

Join our mailing list to get the latest insights on automation

  • LinkedIn Social Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Instagram Social Icon
  • YouTube Social  Icon
TS Master Logo.png

© 2017-2025 CFB Bots Pte Ltd. All Rights Reserved. Tel: (65) 6909 2099 | Email: enquiries@cfb-bots.com | Privacy Policy | Terms of Use

bottom of page