Thanks,

I have to do 3 checks also when looping through the data
what do you think is the best way to lop through (fastest)
--
Helping Is always a good thing


"ryguy7272" wrote:

Simple solution to get you started; no code.
=MID(A7,FIND("#",A7)+1,4)

I'll try to come up with a solution that loops through the data later, when
I have more time.

Regards,
Ryan---

--
RyGuy


"QuietMan" wrote:

Here is what I'm attempting to do...
Check a large range of cells for the text "#"
Once I find a cell that has the "#" text, I need to take the 4 characters
right of the "#" text and place it into a different column

Thanks
--
Helping Is always a good thing