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

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.

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.


Hope this helps :slight_smile:
Regards

1 Like

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.

1 Like

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

1 Like