I need to make an excel macro for work, and I have absolutely no experience doing so. It's probably a simple macro, but it's still outside my capabilities. I need to format all of the cells in column A to the same style.
An example of the data: "%B6280070001598441^Random Name^4912120?;6280070001598441=4912120?"
Obviously the "Random Name" would be a name and the numbers change throught all of the cells. I need to delete the latter half, "4912120?;6280070001598441=4912120?" and move the name to Cell B. So Cell A would have "%B6280070001598441" and Cell B would have the name.
I have gotten a macro that I made to work, but it only formats cell A1. I changed the range to include of all the cells, but it still only does the first cell.
Thanks for any help!