USING EXCEL, delete all text right of the "!" symbol

B

boyd

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
 
M

Marcelo

Hy Boyd

try it

=right(a2,(len(a2)-search("!",a2)))


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"boyd" escreveu:
 
M

Marcelo

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

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?
 
Top