Dim cD As String cD = UserForm2.TextBox33 ' strip special characters first cD = Replace(cD, "#", " ") cD = Replace(cD, "!", " ") cD = Replace(cD, "@", " ") cD = Replace(cD, "$", " ") cD = Replace(cD, "^", " ") cD = Trim(cD)
|Multi-user Excel not reflecting who actually has the file opened||10||30|
|Need a macro to create new values based on one value in column A and values in columns B and beyond.||5||29|
|vba code in excel to save the current open mail item as .msg or .oft file in a location||23||59|
|Mac Excel column treating text as date||2||27|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!