Macro - getting relative cell addresses to flow down

C

chris

I am trying to write a macro to split up the information on a cell, which
contains a dash between a name and a title. I want to put the name in one
cell and the title in another. When I create the macro, it only recognizes
the actual cell that I have used to record the demo, it does not advance down
the spreadsheet to the next cell.

Do you know how I make it go down a cell at the end and go to the next
record/row?

Thanks
 
M

Michael

Hi Chris. You don't need to use a macro or VB code to accomplish what you
want. Make sure there is an empty column next to column with your data.
Select all the cells with name-title and goto data-text to columns and use
delimited by other and enter a "-" (no quotes). HTH
Sincerely, Michael Colvin
 
Top