I'm extremely new Excel and VBA. I came across this amazing thread
https://www.mrexcel.com/board/threads/convert-to-proper-case-with-exceptions.475886/post-2351795
I'm currently using the VBA code referenced in this #4 post by Mike.
I'm trying to amend the CorrectCase function to skip strings that include an integer.
I'm pretty sure i just need to add an If statement within for For loop checking with the following function
I'm hoping this will catch strings such as PL259 or MD5T or even MC-154
https://www.mrexcel.com/board/threads/convert-to-proper-case-with-exceptions.475886/post-2351795
I'm currently using the VBA code referenced in this #4 post by Mike.
I'm trying to amend the CorrectCase function to skip strings that include an integer.
I'm pretty sure i just need to add an If statement within for For loop checking with the following function
VBA Code:
Function HasNumber(sIn As String) As Boolean
HasNumber = sIn Like "*#*"
End Function
I'm hoping this will catch strings such as PL259 or MD5T or even MC-154