Find replace problem
Hi Neil,
Perhaps a formula in a helper column and pull down. Then copy and paste
special values to get rid of the formulas.
Assumes all are nn:nn:nn to start with, 8 characters.
=LEFT(E1,5)&"."&RIGHT(E1,2)
HTH
Regards,
Howard
wrote in message
ups.com...
Hi
I have some numbers denoted thus:-
02:34:56 (they can be any numbers at all separated by Colons
and I want to replace the last Colon with a dot/period so it is
02:34.56
I tried to replace using **:**:** to **:**.** but it fills in with the
latter
How can I achieve please
Neil
|