> in MS Excel you can use the formula
> provided the cell A1 contains smth like
> then you can drag this formula down the column (mouse
> pointer should be on the right bottom cell corner)
I would elaborate this a bit.
Imagine you have incoming data containing both links
starting from "www." and starting from "http://www."
For those starting from "www." my formula will work OK.
But for those starting with "http" you will get http://http://www etc
after you drag down the formula. Definitely not what we want!
Here is a smart formula:
It checks if the first seven symbols are "http://" and if its true, does
otherwise adds "http://"
For maximum safety, you might wish to replace all occurencies of "A1"
in the formula with TRIM(A1)
That will eliminate all leading and trailing spaces, if any, from incoming