Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office
This answer was rated:

How can I generate a file in ASCII format from an Excel

worksheet JA: What's the make and...
How can I generate a file in ASCII format from an Excel worksheet
JA: What's the make and model of your computer? And what version of Excel are you using?
Customer: Lenovo, Mcrosfot OS 10, Excle 2010
JA: Have you installed any updates recently?
Customer: yes
JA: Anything else you want the Microsoft Office expert to know before I connect you?
Customer: NO, all I need is to convert .xls to .ascii
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 14 minutes by:
7/14/2017
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 848
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified

Just characters from 1 to 255?

Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
It is a standard Excel ,xls file
Customer reply replied 6 months ago
I would like to perform the operation myself, so that I can do the same k=later on

Okay, I will send you a file shortly.

Ask Your Own Microsoft Office Question
Hello? Can I post here?
Ask Your Own Microsoft Office Question
Oh! I can, finally!
Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
Please be so kind as to provide me with step by step procedure. Thanks.

Hello, I tried N times to give the answer here but the site just didn't allow me to post anything. Sorry for the delay.

Basically what you require can be done by the function of CHAR.

Please see an example here.

Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
thing happens when I click on the word "here" in the phrase "Please see an example here." The link does not take me to your explanation regarding CHAR.
Customer reply replied 6 months ago
Nothing happens when I click on the word "here" in the phrase "Please see an example here." The link does not take me to your explanation regarding CHAR or the example you mention.
That link is for an example. Just check column B for the formula. Are the shown ASCII codes something you are after?
Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
Please see the attached file NEW.xlsx. What I need to do is to convert this file to ASCII format. In the ASCII file, the first 9 rows are to be omitted and the converted file in ASCII format ought to start from row 10.Microsoft help indicates that this can be done by saving the .xlsx file as .csv or .text, but this does not workThe other option is as under:
How do I output my spreadsheet data as an ASCII, delimited text file?Select: File - Save As... from the main menu
In the Save as dialog that appears, select File type Text CSV (.csv; .txt) from the list of spreadsheet file types.
Press T several times in the list to quickly jump to that entry.
Click to enable the box next to Edit filter settings.
Click Save.
In the Export of text files dialog box that pops up, enter the field and text delimiters of your choice.
The Text delimiter is the character that will surround any text entries in your spreadsheet, to keep each phrase together as an entity, when the file is exported into ASCII formatBut I do not have an option for "File type Text CSV (.csv; .txt)". What I have is file type .csv or .txt. Saving in either of the two results in a simple Text file.Please help with step-by-step instructions of how to save the attached .xls file to a .ascii file.Thanks
> step-by-step instructions of how to save the attached .xls file to a .ascii file.
Okay, you are asking to export a spreadsheet into a TEXT file, not to convert numbers into corresponding ASCII characters.
Just moment. I will get a screenshot on Windows 10 for showing the steps.
Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
The file obtained must have an extension .ascii. Only then will the software package use it as input data

I am working on creating an instructive screenshot. The generated file will be in extension CSV by default, and can be easily renamed to .ascii as required.

Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
far, so good. But how do I go from file with extension .csv to one with extension .ascci? If I just rename the fiel with the ascii extension, it does not work, The subsequent program to which this is to be input does not recognize it as an ascii file,
Is below the ascii file that you are talking about?
https://fileinfo.com/extension/asciiBasically it is just plain text file which can be opened by any text editor program. However, due to the code sets defined by different OS, characters might be interpreted differently. In this case, try saving as Unicode Text or Text (Macintosh) etc.
Ask Your Own Microsoft Office Question

Does it make sense? Any feedback please?

Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
The issue is how do I make the transition from Example.csv to Example.ascii?The file in question has to be read by a program that demands a file Example.ascii.How do I go from .csv to .ascii?
As I said, just rename the from exension .csv to .ascii. If the content can't be accepted or recognised by your application, please let me know their specific technical requirement.
Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
Thanks very much.

FYI - as your Excel sheet got 9 rows on top of the actual table including 5 lines with a few data, the output in CSV format will have the same data at the beginning, I am not sure if it is readable for your application. If not, you may simply manually remove them and make other modifications as necessary.

MIN,,0.04,,0,,,0,0.15,,,,,,,,
MAX,,0.15,,,,,0.12,0.45,,0,0.05,0.1,0.15,0.2,0.25,0.3
WEIGHT,,1.5,,,,,1,1.2,,,,,,,,
BINARY CUTOFF,,0.03,,,,,0.08,0.45,,,,,,,,
_ CUT OFF,,,,,,,,,,,,0.25,,,,
,,,,,,,,,,,,,,,,
DEPTH,DEPTH,PHIE,VSAND,VLIME,VDOL,ANHD,CLAY,SW,PHICUT,VCLCUT,SWCUT,BIN HEFF,XI,XI HEFF,XI FLAG,B-FLAG
6095.67,,0,0,0.302457574,0.587779574,0.002644851,0.107118,0.99,0.04,0.08,0.45,0,-0.702190418,0,0,0
6096.17,,0,0,0.080348671,0.426962871,0.322426458,0.170262,0.99,0.04,0.08,0.45,0,-0.844406634,0,0,0
6096.67,,0,0,0.086950827,0.544967227,0.213088946,0.154993,0.99,0.04,0.08,0.45,0,-0.810016994,0,0,0
6097.17,,0,0,0.144402822,0.630717822,0.098432356,0.126447,0.99,0.04,0.08,0.45,0,-0.745724201,0,0,0
6097.67,,0,0,0.14029414,0.67037214,0.09105872,0.098275,0.99,0.04,0.08,0.45,0,-0.682273751,0,0,0
6098.17,,0,0,0.111836743,0.692771743,0.111041514,0.08435,0.99,0.04,0.08,0.45,0,-0.650911138,0,0,0
6098.67,,0,0,0.061885974,0.739264374,0.122785653,0.076064,0.99,0.04,0.08,0.45,0,-0.632248976,0,0,0
6099.17,,0,0,0.069403248,0.774766248,0.098872503,0.056958,0.99,0.04,0.08,0.45,0,-0.589217445,0,0,0

bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 848
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified
bbao and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Ask bbao Your Own Question
bbao
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 848
848 Satisfied Customers
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP

bbao is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR MY MICROSOFT OFFICE … read more
Moses C
Moses C
Bsc
332 satisfied customers
Is there a way to recover a document accidentally deleted
Is there a way to recover a document accidentally deleted from recycle bin? … read more
Chris L.
Chris L.
Support Specialist
Vocational, Technical or Trade Scho
147 satisfied customers
I installed windows 10 update assistant and now I cannot
I installed windows 10 update assistant and now I cannot open Norton or office programs. click-2-run virtualisation handler keeps popping up. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
My computer crashed a couple a months since than on some
my computer crashed a couple a months since than on some documents I am getting "accessed denied contact administrator" how do I get access to the document … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
I have created a memory book in Word with many photos. Most
I have created a memory book in Word with many photos. Most book publishers need it in a PDF. When I change it to a PDF there are shadows on 1/3 of the page and the typing and photos are smaller fitti… read more
George Sibiya
George Sibiya
PhD
216 satisfied customers
I can not open my skype account. No I did not rearranged my
No I did not rearranged my file folder, Microsoft did automatically … read more
bbao
bbao
IT Consultant
848 satisfied customers
I'm trying to see if I already subscribe to Microsoft Office
I'm trying to see if I already subscribe to Microsoft Office 365. I think I do but the PPT "Designer" tool isn't engaging. Hmmm... … read more
Specialist Sean S.
Specialist Sean S.
Computer Support Technician
819 satisfied customers
My fairly new computer does not recognize me and I don't
My fairly new computer does not recognize me and I don't remember ther password. … read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
Thanks for your time. I am unable to change the line spacing
Hello ~ thanks for your time. I am unable to change the line spacing to single in my document. I went into paragraph, set single as the default however it reverts back to multiple spaces … read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
Every time I see more options. I just wrote a note to the
Every time I see more options. I just wrote a long note to the Lawyer tab. Is there any way you can find question and I send a file and sent a team viewer code and password. I was also requested for K… read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
I did not save a word document and deleted it by mistake.
I did not save a word document and deleted it by mistake … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I can't access the word documents. A box shows up that says
I can't access the word documents. A box shows up that says that states c:\program files x86\microsoft office cannot be opened. I only have access to emails and internet. … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
I bought a new computer and cannot use Word. It says to
I bought a new computer and cannot use Word. It says to activate account, which I *****@******.***--but I've gone through the steps, and the final message says "no license found." … read more
bbao
bbao
IT Consultant
848 satisfied customers
I need assistance with a formula. It needs to identify
I need assistance with a formula. It needs to identify unique data points of a column, coupled with other data points from other columns. I have an example I can send. … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
588 satisfied customers
Need your help again on 2 issues below. One issue is old,
Need your help again on 2 issues below. One issue is old, have to re-format laptop hence showing up again. Another new one but how can I raise a question and engage you specifically?1. Outlook Crashes… read more
IT Miro
IT Miro
Computer Scientist
Bachelor's Degree
157 satisfied customers
I accidently locked a word document and have no idea how to
I accidently locked a word document and have no idea how to unlock it. Can you please give me some advice. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
Recently upgraded to Access 2016; having various issues.
Recently upgraded to Access 2016; having various issues. Problem now is that in a query (i don't write SQL statements; I build queries, etc.) I keep getting error message "Your query does not include … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
588 satisfied customers
I wish to add a gmail account to my outlook (Office 365) I
I wish to add a gmail account to my outlook (Office 365) … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
567 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x