-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Venting!
- Thread starter Brian from Maui
- Start date
Excel Facts
Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
I've seen heaps of that -- spent much of the last 12-13 years as a trainer, and people can get precious about their manuals.
I love the fact that if someone works for a big company they are automatically assigned "expert" status -- like, "Yep, that's our model and it's correct because it was put together by a guy from [Insert name of big investment bank here]. Quick scan of the workbook shows that the user is limited to half a dozen functions and could have put together a much more efficient workbook if they knew a bit more about Excel.
Denis
I love the fact that if someone works for a big company they are automatically assigned "expert" status -- like, "Yep, that's our model and it's correct because it was put together by a guy from [Insert name of big investment bank here]. Quick scan of the workbook shows that the user is limited to half a dozen functions and could have put together a much more efficient workbook if they knew a bit more about Excel.
Denis
Darren Bartrup
Well-known Member
- Joined
- Mar 13, 2006
- Messages
- 1,297
- Office Version
- 365
- Platform
- Windows
I had to read a whole two pages of text explaining that I must use text to columns, copy this here, paste that there, turn it inside out, email it to Mars....
Once I understood what it was trying to do, I got it down to these formula:
=TRIM(PROPER(LEFT(A2,FIND(" ",A2))))
=TRIM(PROPER(SUBSTITUTE(A2," ","."))) & "@myemail.com"
And another one which was telling me to sort on a certain column, open another sheet sort that into order on a column, paste them next to each other, copy the results to here, etc... ended up with a simple VLOOKUP.
Once I understood what it was trying to do, I got it down to these formula:
=TRIM(PROPER(LEFT(A2,FIND(" ",A2))))
=TRIM(PROPER(SUBSTITUTE(A2," ","."))) & "@myemail.com"
And another one which was telling me to sort on a certain column, open another sheet sort that into order on a column, paste them next to each other, copy the results to here, etc... ended up with a simple VLOOKUP.
