Help with spreadsheet formula...

[markesmith]

Hi, I'm using the following formula to generate user names in Excel:

 

=LEFT(A1,100) & B1

 

Forname in A1 and surname in B1

 

this is producing JoeBloggs: what I want is JoeB.

 

Any ideas how I can amend the formula so it extracts only the first letter of the surname?

Thanks

[clareq]

=A1&left(B1,1)

 

Currently your formula is producing the first 100 leftmost characters in A1 and all of B1. The formula above will give all of A1 and the leftmost character in B1

[Devontechie]

try this....

 

=CONCATENATE(A1,LEFT(B1,1))