asked on EXCEL - If cell contains more than 6 characters then go to other cell - How to?
Hi Experts.
I need a simple formula that says if a certain cell has more than 6 characters do nothing and let cursor drop down to cell below.
If there is exactly 6 character then move cursor to another cell.
Thanks for your help.
![Capture.PNG]()
DUMMY-FILE.xlsx
I need a simple formula that says if a certain cell has more than 6 characters do nothing and let cursor drop down to cell below.
If there is exactly 6 character then move cursor to another cell.
Thanks for your help.
DUMMY-FILE.xlsx
Microsoft Excel
Last Comment
chris pike
ASKER CERTIFIED SOLUTION
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.
ASKER
Thanks looks good.
You want an automated procedure to move the cursor to cell H7 if the number of digits/characters in the currently-selected cell is six (6).
If so:
1) There is no formula that will do this; you'll have to use VBA to reselect cells given these conditions.
2) Your "H6" cell scenario is a contradiction. If there are either six or more characters in H6, cell H7 would be selected.
What would be your expected response if there are less than six characters in a cell? Halt there?
-Glenn