Need to remove hypens from typed in telephones (not formatted)!!

Hi

Try using Find/Replace (Ctrl H). That should do the job for you.

Andy.

"trixiebme" <[email protected]> wrote in message
news:[email protected]...
> Rows of typed in phone numbers with hyphens...not formatted cells...how do
> I
> remove the hyphens ONLY?!?!
>
> Please I need an answer FAST!

or you could use = replace(A1,"-","")


"trixiebme" wrote:

> Rows of typed in phone numbers with hyphens...not formatted cells...how do I
> remove the hyphens ONLY?!?!
>
> Please I need an answer FAST!

Hi

Try using Find/Replace (Ctrl H). That should do the job for you.

Andy.

"trixiebme" <[email protected]> wrote in message
news:[email protected]...
> Rows of typed in phone numbers with hyphens...not formatted cells...how do
> I
> remove the hyphens ONLY?!?!
>
> Please I need an answer FAST!

or you could use = replace(A1,"-","")


"trixiebme" wrote:

> Rows of typed in phone numbers with hyphens...not formatted cells...how do I
> remove the hyphens ONLY?!?!
>
> Please I need an answer FAST!

Rows of typed in phone numbers with hyphens...not formatted cells...how do I
remove the hyphens ONLY?!?!

Please I need an answer FAST!

Hi

Try using Find/Replace (Ctrl H). That should do the job for you.

Andy.

"trixiebme" <[email protected]> wrote in message
news:[email protected]...
> Rows of typed in phone numbers with hyphens...not formatted cells...how do
> I
> remove the hyphens ONLY?!?!
>
> Please I need an answer FAST!

or you could use = replace(A1,"-","")


"trixiebme" wrote:

> Rows of typed in phone numbers with hyphens...not formatted cells...how do I
> remove the hyphens ONLY?!?!
>
> Please I need an answer FAST!