Trying to copy cell value from column B over to Column A

TheGift73

New Member
Joined
Jul 17, 2013
Messages
1
Hi,

I have just exported an XML database for my sites posts and pages and have edited it down to the main options I need. (Post title and HTML links)

I found a macro that would make the exported links (originally captured as plain text when using the Wordpress Export tool) clickable which is a start. What I would now like to do is to copy the values of the clickable links (column B) over to the post title (Column A) so that I have a clickable post title and not just a clickable HTML link.

The reasoning behind this is, is that I wish to create a easy to read site map (not XML Sitemap) for some of my articles that I will organise later (Windows, Photography, Android etc)

Here is a link (via dropbox) to part of my database that may give you a better idea. Sorry, could see how to attach a database directly.

Kind regards,

Richard
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,896
Messages
6,175,263
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top