Convert .xlsx file into cedilla (Ç) delimited format

Question

Can you please help me convert a conventional Excel document into an cedilla (Ç) delimited (upper case Ç) format like a .CSV format? To my knowledge it would be saved as a .txt file but with the upper case Ç separating each column of data. An example below of what I'm looking for:

AccountNameÇDateÇAccountStatusÇDateOpenedÇ

What software tools are you using. Is this a programming question? — Peter Smith, Jun 02 '15 at 19:01
@JAL I would be open to using an VBA script if it will work. Thanks. — Jim Johnson, Jun 02 '15 at 19:52
@JimJohnson if this is not a programming question, then StackOverflow is the wrong place to ask. — JAL, Jun 02 '15 at 19:53
@JAL Based off my research this process can only be done using a programming function. — Jim Johnson, Jun 02 '15 at 19:57

score 0 · Answer 1 · answered Jun 02 '15 at 21:51

0

I figured it out. Yes, all of you were correct. It was not a programming question. Here's the steps.

Open .xlsx file
Add an empty column after each column of data and input Ç for each column.
Concatinate all the columns
Save as .txt file

answered Jun 02 '15 at 21:51

Jim Johnson

59
1
6

Convert .xlsx file into cedilla (Ç) delimited format

1 Answers1