Trying to Limit Character and Delete Characters that are Over the Limit

[cmenard]

Hi,

I am using a CONCACTENATE function to combine three cells in Excel (2003) - A2,B2, and C2 (Due to titles being A1, B1 and C1).

After combining the three cells the total number of characters tends to be somewhere between 14-16 characters; however to enter this new cell into Access it needs to be no more than 15 characters long.

How can I program this cell to check to see if the characters exceed the limit of 15 characters and then delete the last character (Since the cells that exceed are always 16 characters long)?

[NBVC]

How about?

=LEFT(CONCATENATE(A2,B2,C2),15)