Good Day
I have excel column with format text which include data in letters , number or letters and number in addition to number of letters or digits are not fixed
so what i need to remove this dot if it is start or end the data only as i tried to remove it through Ctrl+F then choose replace dot but it failed as it changed the field format and data formatting
sample attached
https://ufile.io/w5dgk
so i need any way i can extract and remove this dot without change the format of the filed
Regards
I have excel column with format text which include data in letters , number or letters and number in addition to number of letters or digits are not fixed
so what i need to remove this dot if it is start or end the data only as i tried to remove it through Ctrl+F then choose replace dot but it failed as it changed the field format and data formatting
sample attached
https://ufile.io/w5dgk
so i need any way i can extract and remove this dot without change the format of the filed
Regards