Software

Ask something
Question Locked

please how can i arrange this data into excel

0 helpful
6 replies

by markinze

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Name: John blue
Add : Iron Street
code: 25252
Country: uk
,
Name: John blue
Add : Iron Street
code: 25252
Country: uk
,
Name: John blue
Add : Iron Street
code: 25252
Country: uk
,
Name: John blue
Add : Iron Street
code: 25252
Country: uk

Going down to like 4000 records in Text format. I needed to transfer the data into excel. But i did import the data into excel but when i transpose, all the record stays in a single column. Can i have the data to be in data row.
Please help

6 replies

by seanferd

and turn it into a CSV file. Then import.

by tobif

In my reply I gave a detailed walk through...

by tobif

Paste it into Word.

run replace (Ctrl-h)
1. ^p,^p replace with {MyNewPara}
2. ^p replace with ^t
3. {MyNewPara} replace with ^p

Now: paste this into one column in Excel and run the command to split into several columns, with {TAB} as delimiter.

Depending on what is visible here or not, you may need to adjust the strings slightly.

by tobif

You're welcome.
Regarding your other question: I have no idea.

This discussion is closed to new replies.