Thread: Merging Cells
View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

=LOWER(LEFT(A1)&B1)

You can use "&" to concatenate the contents of cells.

HTH
Jason
Atlanta, GA

-----Original Message-----
How can I use CONCATENATE to pull the first character

from cell A1 and
combine it with the contents of of Cell B1 into Cell C1

example of desired output:
Cell A1 = Bill
Cell B1 = Smith
Cell C1 = bsmith

My attempts at the Formula for C1 have been along the

lines of:
=CONCATENATE((A1????),B1)
.