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

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

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

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

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

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 -