I'm using Excel 2003. I have a spreadsheet that currently has 500 rows of data and just one column (A). For example, the first five rows look like this:
A
1 loremipsum=fufu.com
2 heyheyhey=wuwu.com
3 youyouyouyou=dudu.com
4 helloworld=huhu.com
5 happyhappy=mumu.com
I want to reformat all 500 rows so that the portion of the data after the =
sign on each row is moved to a new column (B), and the =
sign is deleted. Thus, the data will occupy in two columns (A & B), and the first five rows (1-5) will look like this:
A B
1 loremipsum fufu.com
2 heyheyhey wuwu.com
3 youyouyouyou dudu.com
4 helloworld huhu.com
5 happyhappy mumu.com
Can you tell me how to set up a macro? (assuming the solution entails a trip on the macro magic carpet)