d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Excel Help - Paying Fg For Help
Add Reply New Topic New Poll
Member
Posts: 17,713
Joined: Apr 8 2008
Gold: 0.00
Feb 20 2017 02:27pm
Need 2 things. First off, if I have a list in notepad let's say.

Kyle
Josh
Ryan
Eric
Steve

How can I copy/paste this into excel where each name has it's own cell in a column?

Secondly, how can I make them numbered to where I can copy/paste them from excel back to notepad so it shows

1.) Kyle
2.) Josh
3.) Ryan
4.) Eric
5.) Steve

Basically all I want is to make a list I have in notepad numbered like that but I have to be able to change the sizing of the numbers and there has to be a space after the ) and in between the name.

This post was edited by Silenced_Matrix on Feb 20 2017 02:30pm
Member
Posts: 44,246
Joined: Apr 30 2010
Gold: 7,940.00
Feb 21 2017 12:14am
A normal table?
Copy paste from notepad will put them into different columns, and then just highlight all, and make a table.

Can sort it on name or number
Member
Posts: 17,713
Joined: Apr 8 2008
Gold: 0.00
Feb 21 2017 09:30am
I don't want a table. I want a list form with no lines around stuff.
Member
Posts: 8,112
Joined: Sep 23 2006
Gold: 3,558.23
Feb 21 2017 06:41pm
So....you're just looking for an easy way to number the lines? Powershell can do it easy peasy.

Code

$num = 0
$list = get-content C:\Users\q\Desktop\test.txt #<-full path to text file
foreach ($name in $list)
{
$num++
$name = "$num.) $name"
Write-Host $name
}


Open powershell, copy/paste that in, and it'll spit out the numbered names in the console and you can copy/paste it from there.
Go Back To Computers & IT Topic List
Add Reply New Topic New Poll