How to remove "^" from the text

[Manju_Reddy_Kanughula]

I am having a text like ^GSPC So i want remove “^” this symbol

[Yoichi]

Hi,

How about the following?

yourString.Replace("^","")

Regards,

[Manju_Reddy_Kanughula]

it is in column

[Yoichi]

Hi,

How about the following?

CurrentRow.ByIndex(0)=CurrentRow.ByIndex(0).ToString.Replace("^","")

Regards,

[Sudharsan_Ka]

HI @Manju_Reddy_Kanughula

Checkout this steps

• Enable Modern Design by Activity Panel-> Filters-> Show Modern
  
• Excel Process Scope
  • Use excel File
    • Find/Replace Value
      • Where to Search - Excel.Sheet("SheetName").Range("A:A")
        What to Search - “^”
        Replace With - “”

Regards
Sudharsan