Hi Vlad,

=SQRT((X2-X1)^2+(Y1-Y2)^2)

--
Cheers
macropod
[Microsoft MVP - Word]


"Vlad" wrote in message ...
I have two co-ordinates that are given in x,y format.

E.g.
x , y
1 , 1
1 , 5

Is there an excel function or vba function that can be used to
calculate the distance between the two co-ordinates?

Cheers