-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
return max string length
-
S
Return max string length before special character within a cell
Hello, I would like to find the Excel formula (not VBA if possible) to know the longest string before meeting special characters within a cell. Where does it apply? CELL A1 Content The formula related to A2 CELL A2 Content You have earnt:/n1000 points/n/nPress the cross button to enter...- schinois
- Thread
- Replies: 8
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
problem function date add into datepicker on userform
- Started by abdelfattah
- Replies: 48
hi i have problem add years and months days is ok i have textbox1= days textbox2= months textbox3= years when i... -
Vlookup Help
- Started by tomehta
- Replies: 35
Hello In attached excel screen shots, in Col I (sheet 1), I want Col C value (from sheet 2), similarly in Col P (sheet 1) want Col D value( from... -
Split cells based on specific text which may occur multiple times in cell
- Started by charlie_580
- Replies: 25
Hi I wonder if anyone can help? I need to split multiple cells by code, however the code may occur within the original cell more than once. and... -
AVERAGE RANGE CELLS DD:HH:MM FORMAT
- Started by LawNapier
- Replies: 25
I am trying to average the below in DD:HH:MM format. The cells format is set as "custom > DD:HH:MM". I want to only average the time for the... -
Need to color specific cells on another sheet automatically
- Started by csteps
- Replies: 23
Need the cells listed in yellow to color those cells on another sheet automatically [ATTACH type="full"]14354[/ATTACH] -
Move Files To Dynamic Folders Based On Cell Value
- Started by wells
- Replies: 22
Im not sure this is still possible... I referred few posts but they dont work with current office edition.. I have a folder with say around 100...