Excel Replacment

Copper Contributor

I have a file which has a list of angles which have been imported to excel as 327.25.36(degrees,minutes.seconds)

I want to change all the angles in the file to be in the format 327.2536 as the software that reads the data expects this format

Can anyone help ?

Wendy

 

1 Reply

@Wendy_2464 , you may transform by

=REPLACE(A1,AGGREGATE(14,6,1/ (MID(A1, ROW(1:14),1)=".") * ROW(1:14),1),1,)

AGGREGATE finds the position of last dot, when REPLACE it on nothing.