Forum Discussion
Solved
Excel Macro not working on other rows
Hello, This is my first time recording a Macro. This is what I am trying to do: I have a list of data in a column that I want to modify for each row of that column. The data all have a similar form...
The macro only refers to cells in row 5 (A5 and B5) and therefore can't change the output in other rows.
=LEFT(A5,SEARCH(" ",A5)-1)
An alternative could be this formula.
The macro only refers to cells in row 5 (A5 and B5) and therefore can't change the output in other rows.
=LEFT(A5,SEARCH(" ",A5)-1)
An alternative could be this formula.