G Guest Sep 22, 2006 #1 I am trying to delete characters in a Excel cell right of the "!" symbol. Is there a function that can be used to do that
I am trying to delete characters in a Excel cell right of the "!" symbol. Is there a function that can be used to do that
G Guest Sep 22, 2006 #2 Hy Boyd try it =right(a2,(len(a2)-search("!",a2))) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "boyd" escreveu:
Hy Boyd try it =right(a2,(len(a2)-search("!",a2))) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "boyd" escreveu:
G Guest Sep 22, 2006 #3 sorry, I forgot to mention to you use this formula in an aulixar column, copy it down, copy and paste special values. after that you can replace the original data, if it is your proposal hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marcelo" escreveu:
sorry, I forgot to mention to you use this formula in an aulixar column, copy it down, copy and paste special values. after that you can replace the original data, if it is your proposal hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marcelo" escreveu:
D David Biddulph Sep 22, 2006 #4 Marcelo said: "Marcelo" escreveu: Click to expand... sorry, I forgot to mention to you use this formula in an aulixar column, copy it down, copy and paste special values. after that you can replace the original data, if it is your proposal Click to expand... I assume that you intended LEFT, rather than RIGHT, in your formula, Marcelo?
Marcelo said: "Marcelo" escreveu: Click to expand... sorry, I forgot to mention to you use this formula in an aulixar column, copy it down, copy and paste special values. after that you can replace the original data, if it is your proposal Click to expand... I assume that you intended LEFT, rather than RIGHT, in your formula, Marcelo?
G Gord Dibben Sep 23, 2006 #6 Maybe a typo but should be......... Find what: !* Gord Dibben MS Excel MVP
