Is there any way to copy and paste in desired format in excel

Like If I copy these all

LEg5Z.png

If you want to try here is the source url from where I'm copying you can try yourself --> http://www.wcsu.edu/com/faculty/


and want outcome like this:

SSLA5.png

How can I do this?

The last solution was good but there was little problem that some time there are 5 rows and some time 4 so it's messing everything if I go with formula.

is there any way that I copy 1 screenshot items and paste and the outcomes will be like 2nd screenshot with that formula.

Here's the source URL --> http://www.wcsu.edu/com/faculty/

First 3 are 5 rows data while rest are 4 rows data. This is just a sample URL I need to copy in bulk. That's why for me formula option will not work.

Let me wait If anyone with perfect solution comes up.

Thanks AliGW for your help as well.

Actually I was not aware. Yes I'll be careful. I'm waiting if someone replies here. If someone don't answer I'll post another forum with link back to this thread.

Thank you, I'll follow all rules.

Along with many other contributors, I am not able to view .png files on this forum due to software incompatibilities with some browsers. Hence when you say:

and want outcome like this:

it is meaningless, as we can't see what your outcomes are.

It would help if you attached a sample Excel workbook to show what you want to achieve. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

I did as you said. Hope now you can see the attachments.
1st one is what I copy and 2nd one is what I want to see.

They are both images (pictures), so I still can't see them. If you really must upload pictures, then do so in the jpeg or pdf formats.

Pete

I convert both into pdf format. Hope it helps.

I think Ali's suggestion in Post #2 is correct (without having read your previous thread). Paste the data into one sheet, and then use another sheet with formulae in to put the data in the format you require. The formulae should be able to cope with 4-line and 5-line entries, if written appropriately.

Pete