Apr 13 2019 03:00 PM
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
Apr 14 2019 06:44 AM
@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.