Avatar of Pau Lo
Pau Lo
 asked on

punctuation character 'finder' function or formula

Are there any in-built functions in Excel that could analyse the content of a cell, and check for 1 or more instances of punctuation characters, such as full stop, comma, question mark, exclamation mark, semi-colon, colon, ellipsis, brackets, hyphen, speech marks, apostrophe, quotation marks etc (there may be more).

General use case is if we were checking cell A2, the function/formula would return either "no punctuation characters found in cell A2", or "punctuation characters found in cell A2". I've found similar methods of verifying a cell's value is all comprised of 100% numeric character's, or all all alpha A-Z..a-z characters, but there was nothing obvious I could find regarding punctuation characters. I'm trying to do some data quality checks on an extract of data which doesnt appear to have been subject to much data entry validation in its original source application. 


Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Pau Lo

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
byundt

Note that you may need to array-enter the formula (Control Shift Enter) if you are using Excel 2019 or earlier. I'm testing in Microsoft 365, which has the dynamic arrays feature and doesn't need array-entry.
Pau Lo

ASKER
perfect!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck