Solved: How to Replace Horizontal Tab in Excel

[krishhi]

Hello Guys,

I have a weired problem, today i have copied some tables into excel, there some special characters appear like square, when i try to get the code of the box it gives 13.

But i found that special character is "Horizontal Tab" the ASCII code is 9.

When i try with Alt+9, it wont' effect.

How do i enter this horizontal tab character in Excel.?

Waiting for your reply,

Thanks,
Krrish

[mbarron]

=Replace(A1,char(9),"") for a formula

or something like

selection = replace(selection.offset(,-1),chr(9),"") in VBA

[krishhi]

@mbarron

Thank you very much.

Could u please give me an example, when i try this it shows an error message saying that "you have entered few arguments for this function"

[Aussiebear]

Do you have intellisense turned on?

[krishhi]

Do you have intellisense turned on?

intellisense :think: ??

anyway i got it guys with substitute function.