Get instant live expert help on How do I remove whitespace from string
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to remove the numbers/letters after the hashtag and before the bracket from a string such as 7f/Te4 $JGA (#B11)
Solved by C. E. in 18 mins
Hi I want to remove last 6 charactors in a string
Solved by M. D. in 22 mins
Private Sub CommandButton1()
Dim myFormula As String
myFormula = "=IF(ISNA(INDIRECT(""K""&MATCH(M2;B:B;0)));0;INDIRECT(""K""&MATCH(M2;B:B;0)))"
Range("L2").Select
Range("L2").Formula = myFormula
End Sub
When I start this macro code I have error 1004. If I remove from string initialization “=” then in cell “L”” I have regular string witch is not formula.
Solved by O. J. in 11 mins
Use the SUBSTITUTE formula to remove a text string in a cell in order to utilise the value
Solved by E. E. in 14 mins
how to remove the leading three zeros from a multiple string of 14 numbers that are seperated by a , which are all in one cell
example:
00003456765432, 00005436786543, 00002345678765, 00004567890789
keep in mind these are all in one cell in excel
Solved by A. C. in 13 mins