Combine part of text from one col to another

[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

 

[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.

 

[Frank Kabel]

Hi
try
=B1 & LEFT(A1,1)

 

[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

 

[Frank Kabel]

Hi
try
=B1 & LOWER(LEFT(A1,1))

 

[Domenic]

Hi,

try,

=LOWER(B1&LEFT(A1,1))

Hope this helps!