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