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

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

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

Hy Boyd

try it

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


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



"boyd" escreveu:

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

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

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:

Hy Boyd

try it

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


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



"boyd" escreveu:

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

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

"Marcelo" wrote in message
...
"Marcelo" escreveu:

"boyd" escreveu:

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

Hy Boyd

try it

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

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

I assume that you intended LEFT, rather than RIGHT, in your formula,
Marcelo?
--
David Biddulph

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

CtrlH
Find what:!
Replace with:"leave it blank"
Click Replace All

"boyd" wrote:

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

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

Maybe a typo but should be.........

Find what: !*


Gord Dibben MS Excel MVP


On Sat, 23 Sep 2006 09:33:01 -0700, Teethless mama
wrote:

CtrlH
Find what:!
Replace with:"leave it blank"
Click Replace All

"boyd" wrote:

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