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

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

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

1 Like

let me try real quick, shall apprise you

God Bless you. It worked like a charm

new formula

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

2 Likes

:raised_hands: :beers: :smiley:

1 Like

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

1 Like