Replace dashes
 

Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes.
the number should read 12222202 What is the fastest way to do this thanks

Replace dashes
 

Use =SUBSTITUTE(A1,"-","")

The last argument is a pair of double quotes with no space between
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wanna Learn" wrote in message
...
Hello
I have a column of numbers example 12-2222-02 . I need to delete the
dashes.
the number should read 12222202 What is the fastest way to do this
thanks

Replace dashes
 

=SUBSTITUTE(A1,"-","")

Dave
--
Brevity is the soul of wit.


"Wanna Learn" wrote:

Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes.
the number should read 12222202 What is the fastest way to do this thanks

Replace dashes
 

Thank soooo much.

"Dave F" wrote:

=SUBSTITUTE(A1,"-","")

Dave
--
Brevity is the soul of wit.


"Wanna Learn" wrote:

Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes.
the number should read 12222202 What is the fastest way to do this thanks

Replace dashes
 

Select your range to fix
Edit|replace
what: - (dash)
with: (leave blank)
replace all

And maybe applying a custom format after is another way.

Wanna Learn wrote:

Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes.
the number should read 12222202 What is the fastest way to do this thanks

--

Dave Peterson

Replace dashes
 

Dave Thank you. Also I want to thank you for the click sort module in
Contextures you directed me to the other day. Thank you

"Dave Peterson" wrote:

Select your range to fix
Edit|replace
what: - (dash)
with: (leave blank)
replace all

And maybe applying a custom format after is another way.

Wanna Learn wrote:

Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes.
the number should read 12222202 What is the fastest way to do this thanks

--

Dave Peterson

Replace dashes
 

You're welcome.

That's a good site to bookmark.

Wanna Learn wrote:

Dave Thank you. Also I want to thank you for the click sort module in
Contextures you directed me to the other day. Thank you

"Dave Peterson" wrote:

Select your range to fix
Edit|replace
what: - (dash)
with: (leave blank)
replace all

And maybe applying a custom format after is another way.

Wanna Learn wrote:

Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes.
the number should read 12222202 What is the fastest way to do this thanks

--

Dave Peterson


--

Dave Peterson