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

G

Guest

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

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt codes 4
Excel Count If Formula Question 1
HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B 1
Excel changes spelling of word 2
Remove the char from right 2
Easiest way to extract characters in a cell LEFT or RIGHT of a sym 2
Calculate with or without Symbol 1
Using Dependents - what does the small "Table" symbol mean? 1

Top