hi,
Please help how to solve my problem about how to limit 11 digit number inside excel cell.
i want to enter values like mobile number starting 0########## and deletes the excess numbers.

thanks in advance

=LEFT(text, length) should be what you are after

thanks a lot, it's solve now :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.