Get instant live expert help on How do I remove from string

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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