Wanting to create a unique customer number

[Tamstar01]

Hi

I have a created a customer database spreadsheet, however I want each customer to have their own customer number eg. First four letters of Last Name or Company Name (if a company) and their first initial and number 1 going up from 1 from there.

I have no doubt that it can be done, I just don't know how? Any help would be appreciated

[elayaz]

Welcome to forum.

Try this in b4, drag down. Will that work?

Please Login or Register  to view this content.

[Tamstar01]

Awesome! Thanks that will work a treat!!! Thanks soo much!!!!! :-)

[elayaz]

Happy to help

Mark this thread as solved if the reply solved your need.