Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBScript help to convert a column of last names to initials
I have a script that opens an Excel document and I would like to have it take the values of the last name column and replace them with just the first character. I have created a objRange for the column and tried using REPLACE, LEFT & MID with no luck. I will post my script when I get back to...
