Combine part of text from one col to another

E

epac135

I'm trying to combine only part of a string from one column with all th
text of another column.
For instance I want to create usernames to log into a network. If col
has Bill and col2 has Smith I want to get just the B from col1 an
combine it with col2 to make smithb in a new column.

Thanks in advance
 
R

RagDyeR

Try this:

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

=B1&LEFT(A1)


I'm trying to combine only part of a string from one column with all the
text of another column.
For instance I want to create usernames to log into a network. If col1
has Bill and col2 has Smith I want to get just the B from col1 and
combine it with col2 to make smithb in a new column.

Thanks in advance.
 
E

epac135

I also need to change the case of the usernames I now have. I have th
formula to combine the 2 cols to create a username such as SmithJ
however I don't want the S or the J to be capitalized. I'm not sur
how it works to have 2 formulas in the same col.

Thanks for the hel
 
Top