Text to columns

[Pickygame]

Hi

I am wanting to separate names to create an e-mail list. so if i use text to columns on Alan Jones the space separator in the wizard leaves the space as the last character of the first name. how can eliminate the space at the end of Alan?

Example: Cell A1= Alan Jones, text to column then becomes A1 = Alan , Cell B1 = Jones Cell C1 = A1&"@email" the result is:

Alan @email

thanks

[cbatrody]

Instead, you can use the following formula in C1

=LEFT(A1, SEARCH(" ",A1,1)-1)&"@email.com"

[martindwilson]

no it doesn't unless you have 2 spaces in between ,checking the treat consecutive delimiters as one would fix that
or maybe you have a space and some other character that you cant see
what does after splitting =CODE(RIGHT(A1)) return

[AlKey]

may this

=REPLACE(A1,FIND(" ",A1),255,"")&"@email.com"

	A	B
1	Alan Jones	[email protected]