Hi,
(sorry for posting the same question twice, but the topic has changed, since the problem has changed)
Hi,
I've been trying to remove all "spaces" from a text string, but can't get it to work. I just figured out why I am having problems... the "spaces" are not space characters, but they look like them!
Problem:
I paste info from another application into Excel in the following format.
e.g. "100 000.00" (could also be 100 000 000.10, or many other combos).
This is interpreted as text in Excel, since there are "spaces" hard coded in between the numbers.
Goal:
Have Excel interpret this as a number. (e.g. "100000").
It seems like it's not spaces I am dealing with, but some other character that looks like a space... why do I think so? because this function does not work on my pasted data, but it works if I type in "100 000.00" (with a space):
=VALUE(SUBSTITUTE(E2;" ";""))
I am using Excel 97. I don't mind using VBA, but would prefer not to.
Any help would be appreciated.
/Carl
(sorry for posting the same question twice, but the topic has changed, since the problem has changed)
Hi,
I've been trying to remove all "spaces" from a text string, but can't get it to work. I just figured out why I am having problems... the "spaces" are not space characters, but they look like them!
Problem:
I paste info from another application into Excel in the following format.
e.g. "100 000.00" (could also be 100 000 000.10, or many other combos).
This is interpreted as text in Excel, since there are "spaces" hard coded in between the numbers.
Goal:
Have Excel interpret this as a number. (e.g. "100000").
It seems like it's not spaces I am dealing with, but some other character that looks like a space... why do I think so? because this function does not work on my pasted data, but it works if I type in "100 000.00" (with a space):
=VALUE(SUBSTITUTE(E2;" ";""))
I am using Excel 97. I don't mind using VBA, but would prefer not to.
Any help would be appreciated.
/Carl
)...
