G Guest Nov 3, 2004 #1 new addresses that I type in are automatically converted, but ones I copied into the spreadsheet are not. Any ideas welcome.
new addresses that I type in are automatically converted, but ones I copied into the spreadsheet are not. Any ideas welcome.
D David McRitchie Nov 4, 2004 #2 Hi Ben, Were they links where you copied them from. What version of Excel are you using. Does =LEN(A1) match the number of chars you actually see and ="*" & A1 & "*" show anything resembling spaces Does use of the the TrimALL macro fix them (make them links) : http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Hi Ben, Were they links where you copied them from. What version of Excel are you using. Does =LEN(A1) match the number of chars you actually see and ="*" & A1 & "*" show anything resembling spaces Does use of the the TrimALL macro fix them (make them links) : http://www.mvps.org/dmcritchie/excel/join.htm#trimall
