I need a formula that will tell me how many alt enters are in a cell.
If my cell A1 has the following data, the formula should return 2.
Cell A1:
Project 1 Final Submission
Proj 30 Test DB
Initiation of Projects
Thank you
I need a formula that will tell me how many alt enters are in a cell.
If my cell A1 has the following data, the formula should return 2.
Cell A1:
Project 1 Final Submission
Proj 30 Test DB
Initiation of Projects
Thank you
Try this...
=LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(10),""))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This is perfect. Thanks so much.
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks