Hi, first of all sorry if this is in the wrong sub-forum, I just joined here!
What i need is a way to import plain text to excel, in the form of paragraphs, then split each paragraph up into separate columns. As there are a lot of these to do, i would love a keyboard shortcut or macro!
Also, when importing the text file to excel it puts all of the paragraphs into the first cell. I need to put each paragraph into a new cell below before splitting into columns.
Here's an example of a paragraph:
Northlands, co. Cavan, on a mount, vert, a
cross crosslet, fitched, (charged with a
bleeding heart) Pl 58, cr. 6
Now, i need this paragraph split into 3 columns [Surname, Description, id number (e.g. pl 58, cr.6)]. Each paragraph has a completely different length and surname description.
Any help is greatly appreciated!
What i need is a way to import plain text to excel, in the form of paragraphs, then split each paragraph up into separate columns. As there are a lot of these to do, i would love a keyboard shortcut or macro!
Also, when importing the text file to excel it puts all of the paragraphs into the first cell. I need to put each paragraph into a new cell below before splitting into columns.
Here's an example of a paragraph:
Northlands, co. Cavan, on a mount, vert, a
cross crosslet, fitched, (charged with a
bleeding heart) Pl 58, cr. 6
Now, i need this paragraph split into 3 columns [Surname, Description, id number (e.g. pl 58, cr.6)]. Each paragraph has a completely different length and surname description.
Any help is greatly appreciated!
