Looking for formula to meet the certain conditions in a cell

M

Mifti

New Member
Joined
Dec 22, 2020
Messages
5
Office Version
  1. 2016
Platform
  1. Windows
Hello,

Can someone help me to find formula or VBA for the scenario:

  • Cell can be blank
  • If not blank, then first character must be a letter
  • Characters after first letter are optional but must be numbers
Thanks in advance for this great help!
Example
 

Attachments

  • Example.jpg
    Example.jpg
    10.9 KB · Views: 5

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
How about
+Fluff v2.xlsm
AB
1
2ok
3Aok
4A123ok
51Anot ok
6Ab12not ok
71not ok
Main
Cell Formulas
RangeFormula
B2:B7B2=IF(AND(ISERROR(LEFT(A2,1)+0),IF(LEN(A2)>1,ISNUMBER(MID(A2,2,99)+0),1)),"ok","not ok")
 
Upvote 0
Solution
Thank you very much Fluff! Formula works perfect.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Calculating Multiple Columns with SUMIFS
Replies
3
Views
178
Joe4
Joe4
Ramballah
  • Solved
Finding the first certain value with conditions
2
Replies
18
Views
274
mumps
mumps
J
  • Question
Excel VBA Help
Replies
9
Views
239
justincaza
J
N
  • Question
Formula help to search a table for a date greater than today that has a non-blank cell and return the date in a separate cell.
Replies
2
Views
150
Alex Blakenburg
A
M
  • Question
Dynamic calculations based on Dates
Replies
1
Views
147
Kaper
Kaper

Forum statistics

Threads
1,214,572
Messages
6,120,306
Members
448,955
Latest member
Dreamz high

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top