Text import question

[NewtoSS]

Hey All,

I am a fairly new excel user. I have read tutorials about using the text import wizard and text to columns but I am having trouble getting it to work for what I am trying to do. I want to copy the relevant text from a linkedin profile (name, company, title) and paste it into spreadsheet columns (first name, last name, title, company), ideally from the clipboard without having to paste into a notepad file first. What I have been doing is a paste special and then using the little clipboard menu to 'format data', but I don't always get that option. Is there a way to use the import data option for pasting test from the clipboard? Also, when I do get the wizard to pop up it wraps the title into the same column as the name and I end up doing a cut and paste. Any ideas?

 

[Tinbendr]

You can record a macro performing all the tasks you need to get the data formatted the way you like it. Then, when you need to import it again, just run the macro.