I should know this...but hey it's Monday!

[Lorimare]

I have this number: 00034-1019-01

I want to remove the dashes. Do I use TRIM function, and if so could you supply the verbage?

Thank you

 

[Golom]

Use Replace
[blue][tt]
NoDashes = Replace ( "00034-1019-01", "-", "" )
[/tt][/blue]

 

[Lorimare]

I have to do this for 256 rows of numbers with similar formatting. I should probably use the LEFT or RIGHT function.

 

[Golom]

I suppose you could
[blue][tt]
NoDashes = Left$( myValue, 5 ) & Mid$(myValue, 7, 4) & Right$( myValue, 2 )
[/tt][/blue]
but Replace does seem more compact.