| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Numeric code of spaces!
Hi!
I imported a textstring from the webb into excel, when doing so I got a few spaces aswell. I managed to remove them (The replace function). BUT The space character I removed had a numeric code 160. The normal space key has value 32!!! Why is this? Can anybody explain this! Thanks /Johan |
|
#2
|
|||
|
|||
|
It's an HTML code for nonbreaking space.
Here's a table of the HTML codes. http://www.lookuptables.com/ Make sure you pick HTML Codes from the menu at the top. (Blue with Yellow lettering.) tj "Johan" wrote: Hi! I imported a textstring from the webb into excel, when doing so I got a few spaces aswell. I managed to remove them (The replace function). BUT The space character I removed had a numeric code 160. The normal space key has value 32!!! Why is this? Can anybody explain this! Thanks /Johan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Command Button VBA code | Excel Discussion (Misc queries) | |||
Hybrid Mode
