Remove Tab like space before a string in excel (Trim and Replace arent working)

[KP6689 (KP)]

For lack of a better explanation, I used ‘Tab like’ space phrase here, pls refer to the screenshot

Excel function - Trim isnt able to remove it,
neither is Assign = element.Replace(" “,”“).Replace(” “,”“).Replace(” “,”")

Please help

[kaderms (Kader)]

Tab should be chr(9)
You can try replacing chr(9) from the string, with empty char.

[KP6689 (KP)]

let me try real quick, shall apprise you

[KP6689 (KP)]

@kaderms

chr(9)

God Bless you. It worked like a charm

new formula

element.Replace(" “,”“).Replace(” “,”“).Replace(chr(9),”")

[kaderms (Kader)]

[kaderms (Kader)]

chr(9) and trim should do the job for you, unless you want replace any spaces in between the text too.

[Karan_Zaveri]

i am getting error while using chr(9) in assign activity.
do we need a package or something that I am missing?

.