Importing notepad data to excel difficult split

0 votes

I want to transfer this data from notepad to excel and split it into columns but the problem is that the data (i didn't make this) doesnt split on a delimiter. All the data looks like variations of the following this

Header: "a" "b" "c" "d" "e" ... "n"
rows:   "1" "sgvgs-dvfds" "" "0.0" "d'/.d" ... "m"

Everything is contained within quotations. Does anyone know in excel on how to make it happen or even through powershell?

Feb 18, 2022 in Others by Edureka
• 13,670 points
219 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 23,260 points
6,203 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
13,294 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,420 points
485 views
0 votes
1 answer

Runtime error 438 while importing data in excel from secured website using VBA

Replace With ieDoc.forms(0) .userType.Value = "1" ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,420 points
669 views
0 votes
1 answer
0 votes
1 answer

Add .xll as AddIn to Excel

Hi, for adding an xll as Addln ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
918 views
0 votes
1 answer

VBA excel - create skype account using powershell script

Although the PowerShell portion has not been ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,420 points
408 views
0 votes
1 answer

Copy formula from Excel to Notepad++

If you go to Formulas card, inside Formulas Auditing section there ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 63,420 points
925 views
0 votes
1 answer

How can I convert uppercase letters to lowercase in Notepad++

Simply choose the text you wish to ...READ MORE

answered Jan 3, 2023 in Others by narikkadan
• 63,420 points
6,292 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP