-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Getting #VALUE! error while calculating time difference
- Thread starter Gautham A
- Start date
Excel Facts
Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,459
- Office Version
- 365
- Platform
- Windows
I am guessing that the data you were running this against comes from another source, like the Web or was imported or exported to Excel from another data source?
The reason I say that is because Fluff's code replaces a special space, that is often found in those kind of files. The other suggestions we made only work on normal, regular spaces.
For future reference, mentioning those kind of details (where the data is initially coming from) may help you to get an answer sooner, as we then have a better idea of what we are dealing with.
The reason I say that is because Fluff's code replaces a special space, that is often found in those kind of files. The other suggestions we made only work on normal, regular spaces.
For future reference, mentioning those kind of details (where the data is initially coming from) may help you to get an answer sooner, as we then have a better idea of what we are dealing with.
Upvote
0
Similar threads
- Question
