| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove a - from text
or use:
=SUBSTITUTE(A1,"-","",1) On 14 Kwi, 14:36, seshuramakrishna wrote: I have a Very Easy logic for this u do one thing simple use find and replace... -- seshu "Mark Allen" wrote: Is it possible to create a formula to remove a - from a cell?? Example: A Â* Â* Â* needs to be Â* B 445-2134 Â* Â* Â* Â* Â* Â* Â* 4452134 er-6978 Â* Â* Â* Â* Â* Â* Â* Â* Â*er6978 7777-99987 Â* Â* Â* Â* Â* Â*77799987 Hope you can help me please!! Regards Mark- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easiest way to remove text from a cell that has text and numbers? | Excel Discussion (Misc queries) | |||
| Filter text in a column by its Indent, to remove certain text | Excel Discussion (Misc queries) | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
![Jarek Kujawa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
