Concatenating symbols in a string?

[RustyNail]

Hello,

I was just wondering how can we concatenate symbols to our strings. I need to concatenate a bullet "●" in the string but it doesnt seem to take it????
When I go to paste the bullet, it turns into a question mark ???

Please Login or Register  to view this content.

In any case I will make a new thread about this....

Thanks

RN

[MrShorty]

From what I understand, VBA does not play particularly well with UNICODE characters (at least, the ones beyond the standard ASCII characters). I think you will need to use the AscW() [https://msdn.microsoft.com/en-us/vba...s/asc-function ] and ChrW() [https://msdn.microsoft.com/en-us/vba...s/chr-function ] in order to work reliably with those characters.

[AliGW]

Duplicates are not allowed, so this thread is now closed.

Continue in the original thread here: https://www.excelforum.com/excel-pro...o-strings.html