Forum Discussion
sf49ers19238597
May 17, 2024Iron Contributor
I have file need help with formula not working some reason for Time.
I have file need help with formula not working some reason for Time. I have file call NFL Schedule have teams for friends. in time it not display any time that get data from Yearly schedule works...
Patrick2788
Silver Contributor
You can use find/replace but must be careful that you select only the cells which might have spaces before doing ctrl+F.
In the Find what: there's one space entered. Replace with is blank
When I removed the spaces from the team names, I made sure I did not select any other cells (even the headers) besides the team names.
sf49ers19238597
May 18, 2024Iron Contributor
I try that did not work. I use trim it work have copy and paste value
- Patrick2788May 18, 2024Silver Contributor
Find/Replace could be missing if it's also looking for a cell format. May have to clear it, if set: