cgmojoco
Well-known Member
- Joined
- Jan 15, 2005
- Messages
- 699
Hi there-
Need a macro that will search each cell in column J
Find value after the ","
Place the value in cell column H on the same line
Example of cell in column J
HENDERN, 12
I need to extract the 12 and put it in the H column on the same row
Also need a check run to make sure each value in column J has a comma in it, if not, error.
Need a macro that will search each cell in column J
Find value after the ","
Place the value in cell column H on the same line
Example of cell in column J
HENDERN, 12
I need to extract the 12 and put it in the H column on the same row
Also need a check run to make sure each value in column J has a comma in it, if not, error.