| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove a - from text
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a - from text
Hi Mark,
You can use the replace function: =SUBSTITUTE(A1,"-","") Judith -- Hope this helps "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a - from text
Use SUBSTITUTE() text function
-- If this post helps click Yes --------------- Jacob Skaria "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a - from text
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a - from text
Hi
assuming data start at row 2, try this in B2 and copy down =SUBSTITUTE(A2,"-","") or try Go to Edit on the Menu bar Select Replace type - in the Find what leave empty in Replace with click Replace All Close -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "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 |
|
#6
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 - |
| Reply |
| 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 | |||
Linear Mode
