• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

to export data from excel to notepad as semicolon and side to side

I have one excel file and it consists of the cell of 468 and I need them in word or notepad as semicolon between each other
for example

in Excel

1.Test1
2.Test2
3.Test3
--
--
--
468.test 468

and I would like them within notepad or word as semicolon between each other as sequentially and side to side

Test1;Test2;Test3;Test4 ............ ;Test468

how can I do this? thanks
0
TRocex
Asked:
TRocex
  • 2
1 Solution
 
als315Commented:
You can use this function:
Public Function Concat(R As Range) As String
Dim c
Concat = ""
For Each c In R
        Concat = Concat & c.Value & ";"
Next
Concat = Left(Concat, Len(Concat) - 1)
End Function

Open in new window

Look at sample
Concat.xls
0
 
TRocexAuthor Commented:
thanks so how I should run your function or where should I write this function in excel?
0
 
als315Commented:
Look at sample. There is function and example. You can press Alt+F11 and in Module1 you will see Function
0
 
Paul SauvéRetiredCommented:
Another approach is to copy the Excel column as a table to Word and use the Table to Text function with a semicolon as a delimiter!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now