Reputation
5,862
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 15 36
Newest
 Yearling
Impact
~1.5m people reached

Aug
11
answered How do I prevent VLOOKUP from breaking after I add a column to a named range?
Aug
11
answered How to render some text with given font file?
Aug
11
answered How do I transpose and combine cells in Excel?
Aug
11
revised Excel Conditional Formatting for Cell condition in Range
added 484 characters in body
Aug
11
answered Excel Conditional Formatting for Cell condition in Range
Aug
10
revised Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
added 144 characters in body
Aug
9
revised Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
added 663 characters in body
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
I'll update my answer shortly to help you parse the time string. You'll need to add a space between the time and the AM/PM notation. Then use VALUE to let Excel interpret it as a time.
Aug
9
answered Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Aug
9
answered Photoshop text spacing issue
Aug
8
revised Split a string in a cell in Excel using numbers as the divider
added 44 characters in body
Aug
8
comment Split a string in a cell in Excel using numbers as the divider
After pressing those keys, the formula should get enclosed in braces ("{ }"). That's how you can tell it's been entered as an array formula.
Aug
8
comment Split a string in a cell in Excel using numbers as the divider
First, copy the formula, then paste it into the formula bar. Instead of pressing Enter like you normally do when entering data, press Ctrl+Shift+Enter altogether.
Aug
8
answered Split a string in a cell in Excel using numbers as the divider
Aug
6
answered Excel conditional formatting of row
Aug
2
revised How do increase row height in excel by X. ie. Add verticle cell padding
added 54 characters in body
Aug
1
comment How to sort an Excel spreadsheet columns by row contents?
+1 I learned something new today!! :)
Aug
1
comment How can I dim my computer screen beyond the minimum?
I see. The icon looks looks like a black box. When I ran it the first time, the icon was hidden. I had to set it to "Only show notifications." I wish there was a better app though. But I guess it still helps keep eyestrain at bay for me for a while.
Aug
1
revised How do increase row height in excel by X. ie. Add verticle cell padding
deleted 34 characters in body
Aug
1
answered How do increase row height in excel by X. ie. Add verticle cell padding