Member Avatar for Jemuel

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

  • 2 Contributors
  • 2 Replies
  • 124 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by Jemuel
Member Avatar for hericles

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

Member Avatar for Jemuel

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.