Member Avatar for 4ukh

dear experts,

I just want to wave the last digit of each cell's value like 20001 should like 2000 using ms excel 2007.

please consider this table:
20001 2000
20011 2001
20021 2002
20041 2004
20042 ????
20043
20044
20045
20046
20051
20052
20053
20061
20062
20063
20071


any help

thank you

4ukh

  • 2 Contributors
  • 2 Replies
  • 93 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by 4ukh

Recommended Answers

All 2 Replies

Member Avatar for vb5prgrmr

Result = Left(String, Len(String) - 1)

Good Luck

Member Avatar for 4ukh

Result = Left(String, Len(String) - 1)

Good Luck

thank you vb5prgrmr it works and you save my time and now i can go home early :P :P :P :P :P :P :P :P :P :P .

thanks once again


4ukh

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.