Read Range /Write range convert string with " ' " character

[qlka08]

Hi everybody
I’ve got this scenario:
In one excel file I’ve got range where in one column is string with " ’ " at the beginning for example:'123457890. When I am copy this range to another file with read range/ write range activity, character " ’ " is displayed but formulas like Look Up doesn’t work. It looks like excel doesn’t recognize " ’ " character. When I made loop which add this character in every cell everything works fine but I’ve got a lot of rows so it takes too much time. Does anybody know why it happened to me😉?
I will be grateful for any advice.

[Raghavendraprasad (Raghavendraprasad Bhat)]

For you to copy over formulas in excel here are many workarounds and solutions through code, activities and hot keys are suggested. check the following links.

Copy and paste formulas

I want to copy a formula to a range of cells. The range of cells changes with each iteration of the robot by copying a row and insert copied cells. I have a defined name for the cell that I want to ctrl-c and a named range that moves with the insert. My problem is I haven’t found a way to get the robot to make either name “current”. I don’t find a select range, goto range or similar. Maybe I need to go through the menus to use goto? sort of answering my own question but it would sure mak…

Write formula in excel

I think there is a problem in your formula. [image] Using write cell you can set the value to a valid formula.

How to copy formula to the whole column

Hi @jibanjyoti i posted one question https://forum.uipath.com/t/how-to-search-specific-values-in-whole-excel-sheet/7862 can you please help on this. thank you

Fastest way to write an excel formula into an entire column

Hello folks, My requirement is to generate the Excel report every day. My doubt is once the execution is finished the excel row counter will back to its default value. If execution starts again on tommorow how does it know it should write the cell value in A4 or A5 etc. Could some suggest on the same

Hope this helps
Regards

[mcicca (Marco)]

There could also be potential to replace the ’ character with the standard ’ one, if that’s what is causing an issue. This happened to me in a past project and was struggling until I figured out they are two different characters.

[Raghavendraprasad (Raghavendraprasad Bhat)]

Yup that is rare but very important thing to know Thanks for adding to the answer