| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
| Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Where is text to speech in excel 2003? | Excel Discussion (Misc queries) | |||
Linear Mode
