PDA

View Full Version : delete spaces



zcy198236
11-23-2009, 11:34 AM
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?

Bob Phillips
11-23-2009, 12:12 PM
Try

=SUBSTITUTE(SUBSTITUTE(A1," ",""),CHAR(160),"")