I frequently copy code like KPN NA from bloomberg to excel. When I paste the code in excel or word. These is always spaces in between K_P_N__N_A? how to use a simple routine get rid of these spaces?
I frequently copy code like KPN NA from bloomberg to excel. When I paste the code in excel or word. These is always spaces in between K_P_N__N_A? how to use a simple routine get rid of these spaces?
Try
=SUBSTITUTE(SUBSTITUTE(A1," ",""),CHAR(160),"")
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber