hi everyone..
i have few cells combination text and number that need to convert to all caps for each text letter
for eg:
gnc0104698 - convert to : GNC0104698
gnc0104699 - convert to :GNC0104699
gw0125242 - convert to : GW0125242
gnc0104700 - convert to :GNC0104700
gnc0104701 - convert to :GNC0104701
gnc0104702 - convert to :GNC0104702
The maximum "number" after the code (text) must have 7 digits i have almost 4000 cells to convert! please help !
your solutions on this are very-very much appreciated.thank you! ~ love!~
Bookmarks