View Single Post
 
Old 11-23-2021, 04:48 PM
Stephen Ray Stephen Ray is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Sep 2018
Location: Kansas
Posts: 34
Stephen Ray is on a distinguished road
Default

Guessed, Thank you for your reply. But this document is not saved anywhere, it comes from an application that I work with; the original input document that is not in Word Format. I copy the whole enchilada - original information by highlighting it and Cntrl + C.
With all the information in the clipboard, I turn to a second monitor where Microsoft Word is waiting. I immediately start a macro which pastes all the information and arranges it in a Word document. The Macro saves lots of time and effort by re-arranging it all.

But I need to be able to test when the full name is present or not.

I thought I would highlight and SELECT the area where the Full Name is supposed to be. (The VBA MACRO can easily highlight and SELECT the area where the Full Name is supposed to be). If I could test the SELECTION for Alpha or Alphanumeric that would work.

But from my searching there is only a ISNUMERIC. There is no ISALPHANUMERIC test.
Reply With Quote