Help with white space

**komet12** · 10-25-2009, 10:37 AM

Greetings,

This is a delima I cannot figure out. I had to create passwords for a website we are building. I have 3000 employee numbers has to be used. So what i did was took the first initial and middle initial and last initial and first 5 of the ID number. I did a comma delimiter to obtain all of the letters and numbers. example: ABC12345

My problem is none of the passwords work because when I imported the letters and numbers into the sheet it looks just like the above. However on review I cut and pasted back to notepad and the data looks like this:

"A B C 12345"
So its adding a tab in the password thats thats a problem, How do I remove this extra white space between each comma delimited digit? without having to manually delete it ?

Thanks
Randal

**Special-K** · 10-25-2009, 10:45 AM

Use Text to Columns with TAB delimiter then just concatenate the result A1&B1&C1&D1

**martindwilson** · 10-26-2009, 01:09 PM

not sure if it's tab
trydeleting first character to leave say in a1
" B C 12345"
then use in another cell
=code(a1) you'll get whatever code is causing the space
then use find/replace on the whole column
find
hold down alt and on the number key pad type whatever character code was returned
replace with nothing

**Cheeky Charlie** · 10-26-2009, 04:59 PM

^ or, same but with less work, just select an offending cell, select the "space" (Don't care what character number it is...) - Ctrl+C - then paste into find+replace and replace with nothing, as described.

CC