The get the first letter in a field simply use the model: LEFT(A1,1)
The extra columns for spaces and the hash character are unnecessary. You could simply use this model instead: CONCATONATE(A1," ",B1)
The get the first letter in a field simply use the model: LEFT(A1,1)
The extra columns for spaces and the hash character are unnecessary. You could simply use this model instead: CONCATONATE(A1," ",B1)
Kuroi Web Design and Development | Twitter
(Questions answered in the forum only - so that any forum member can benefit - not by personal message)