sorting out data based on 3 alpha characters followed by a comma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The report I download has a column heading "Name" and is in column D. The
name is last name then a comma then a space then the first name, for example
SMITH, FRED.

I would like to write a macro that would generate a report to pull only the
last names with 3 characters or less. That new report would be on a sheet
titled, "Short Names". Any ideas on how to accomplish this? Thanks
 
SITCFanTN said:
that would generate a report to pull only the
last names with 3 characters or less.
Click to expand...

What do you mean? What happens if you have
SMITH, FRED.
SMITHSON, SARAH

Do you want SMI for both?

Mat
 
What I want to accomplish is having a sheet that lists all the 3 character
last names or less from the main report called "All Records". Names like
"Ray", "Fox", "Lee" or " Hu". I hope that helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to specify only if 3 characters or less 3
List sorting and macros 3
Sorting Alphanumeric data 6
Import a comma delimited file & match records 3
Separate first and last name in two columns 3
Eliminating commas if they are first characters in a string 11
alpha character not populating in DBA table 2
Removing non Alpha Numeric Characters 6

Back
Top