This is my first go at VBA so still
getting to know the ropes. The brain is 63 years old

Below is my first go at this exercise. Still not sure on the loop
actions however.

If you can give me some hints as to the correct action and I will
try!! and get it together.


Private Sub Extract Text_Click()
st1= "location,"
Range ("A1").Select
Do
cells ( ,9) = Right (St1, )
Do
loop until IsEmpty=true
cells


Do I need to put any Dim statement? Boolean?
The text  (after location,) can vary in length
Entry of town is in the next available cell
should the second part of instructions be inserted into first
Needs some closing codes.


Where is a good place  to find out entries to open instructions, and
to end  instructions.
I did say  I was a learner.