To remove the first letter cell in UiPath

[victorialim]

Hi All,

I will be copying and pasting cell A1 to cell JL4.
I have a sequence of steps I have to follow and the last step will be removing the ’ from cell JL4 after I have pasted, so it will populate as the BBG formula.
Can I confirm if there is a way I can remove the ’ after I have pasted it to JL4?

[Yoichi]

Hi,

Can you try Substring method as the following?

Regards,

[muhammedyuzuak]

Hi @victorialim,

Alternatively, you can use the replace method if there are no more ’ signs.

newValue = value.Replace(“'”,“”).ToString

Regards,
MY