Hi,

I am building a dashboard with Excel but using .Net to automate some of the data which needs copying and pasting into the workbook. i have a column within Excel that have spaces within the string that i need removing. For example all numbers in Column B need removing leaving just the value.

How do i tell .net to do this

I tried using the below WB1Ws = Dim WB1WS As Excel.Worksheet

WB1WS.Range("g2 ").Formula...