Remove the dashes

Reply #10

dr san — Sat, 10 Feb 2018 11:46:26 GMT

Can it be a notepad

Reply #9

timmsy — Sat, 10 Feb 2018 10:15:24 GMT

that error is the file path ::: filename = ThisWorkbook.Path c:\windows\temp\textfile- Format(Now, ddmmyy-hhmmss ) .txt some

change the output path c:\windows\temp\ to some folder on your pc that suites you

Reply #8

dr san — Sat, 10 Feb 2018 09:02:46 GMT

error=

Open filename For Output As #1

Reply #7

timmsy — Fri, 09 Feb 2018 12:44:12 GMT

dr san this should work for you

Sub saveText2()

Dim filename As String, lineText As String

Dim myrng As Range, i, j

filename = ThisWorkbook.Path c:\windows\temp\textfile- Format(Now, ddmmyy-hhmmss ) .txt

Open filename For Output As #1

Set myrng = Range( numbers )

For i = 1 To myrng.Rows.Count

For j = 1 To myrng.Columns.Count

lineText = IIf(j = 1, , lineText ) myrng.Cells(i, j)

Next j

Print #1, lineText

Next i

Close #1

End Sub

Reply #6

timmsy — Fri, 09 Feb 2018 12:32:26 GMT

can you post an example of your excel sheet for me

Reply #5

dr san — Fri, 09 Feb 2018 12:23:43 GMT

Hello,TIMMY I need to convert excel sheet numbers

For text

Ex

00 00 00 00 ... .txt

In other words, numbers in a macro, convert to .txt (00

Reply #4

notmyday — Fri, 09 Feb 2018 11:10:59 GMT

You can also in notepad just edit replace find - replace leave blank and done

Reply #3

timmsy — Fri, 09 Feb 2018 11:05:34 GMT

here is the vba code to remove the dashes

Sub removethedashes()

Dim objRange1 As Range

Dim objRange2 As Range

'Set up the ranges

Set objRange1 = Range( A1:A200 )

'Set objRange2 = Range( A21:A35 )

'Do the first parse

objRange1.TextToColumns _

Destination:=Range( A1 ), _

DataType:=xlDelimited, _

Tab:=False, _

Semicolon:=False, _

Comma:=False, _

Space:=False, _

Other:=True, _

OtherChar:= -

End Sub

Reply #2

timmsy — Thu, 08 Feb 2018 20:12:59 GMT

I will upload a quicker way soon for your excel with a vba

Reply #1

Johnebench — Sat, 27 Jan 2018 22:22:53 GMT

Got it!! I used notepad. I copy and pasted the numbers with dashes. Then I copied the tab space between the numbers and pasted into (find what) replace with (space) Done.

ETA: I used excel to remove the dashes in text to columns thats why I had a tab between them.

I'll try it straight into notepad next.

Remove the dashes

Johnebench — Sat, 27 Jan 2018 21:26:21 GMT

Hi all, I was wondering if it's possible to remove the dashes between numbers like these.

Now that I think about it can I put the dashes in number sets where there are none. I have excel.

TIA

0-8-2

0-9-5

1-4-0

1-4-4

1-4-9

1-5-0

1-5-5

1-7-0

1-9-5

1-9-7

2-1-5

2-8-2

2-8-6

2-9-1

3-5-0

3-5-2

4-0-2

4-0-3

4-0-6

4-3-3

4-4-2

4-7-3

4-7-4

4-7-7

4-8-2

4-9-3

5-1-4

5... [ More ]