-1
down vote
favorite
I unfortunately have an un-changeable data source which pull data per the image below. My goal is to include within a current macro, code which will recognize all cells within a dynamic column (L) that have a single entry (i.e. do not begin with a numeric value) and add "1. " to the beginning of each. I've been playing around with this for a while and am stumped. Any suggestions?
Sample
Column A Column B
Row 1 Participant Role
Row 2 1. Participant A 1. Role A
2. Participant B 2. Role B
*Basically I would like the code to automatically format any cells with the default value similar to that displayed in "Row 1" to be changed to the numeric format displayed in "Row 2".
Thanks!
Bookmarks