Email exported to excel, values not getting trimmed

[ThrottleWorks]

Hi,

I have code which exports e-mail body to excel sheet.


I am deriving key words from e-mail body in a cell. For example, ‘ CQAM AAAQUE ‘. But when I try to trim this value, I am not able to do it.

I tried using Trim function as well as rng = trim(rng).

Can anyone please help me in this.

 

[Chihiro]

Try also CLEAN (Worksheetfunction) and check for UNICODE characters.

 

[shrivallabha]

You need to first find out the character first. If above string is in A2 then if you apply following formula in an empty cell then what do you get?
=CODE(LEFT(A2,1))

 

[ThrottleWorks]

Hi @Chihiro sir, thanks for the help. I am checking this and will revert with details.

Hi @shrivallabha , thanks for the help, I am getting 160 as result, I applied this formula in 11 rows, only in 2 rows, I get 32

 

[Chihiro]

See method used in thread below. As sometimes there could be invisible characters embedded between visible ones as well (not just space).

http://chandoo.org/forum/threads/convert-text-to-numbers.28395/#post-169946

 

[shrivallabha]

Please see workarounds mentioned in the below links also:
http://www.rondebruin.nl/win/s9/win017.htm

https://support.office.com/en-us/ar...rom-text-023f3a08-3d56-49e4-bf0c-fe5303222c9d

 

[ThrottleWorks]

Hi @Chihiro sir and @shrivallabha , thanks a lot for the help.
Am checking this and will revert with details.

Good night.

 

[ThrottleWorks]

Hi @shrivallabha , below is working for me ! Thanks a lot.

http://www.rondebruin.nl/win/s9/win017.htm