View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kevin_jones01 kevin_jones01 is offline
external usenet poster
 
Posts: 1
Default Copy First Character of a cell

I am trying to copy the first character of a cell and combine it with another
row and place it in another row. I am trying to create usernames from two
columns First Name and Last Name. I am trying to use Concatenation is this
possible. How do I do this?

Example:

First Name Last Name Username

Jim Bob jbob
Sally Richards srichards