Register Now
You need to be registered to access all features and be part of the community.
Don't worry it's free !
Register Now
Lost Password
Lost your password? Please enter your username and email address. You will receive a link to create a new password via email.
Sometimes a powerful feature in an application gets lost among the others so much so that it never gets the recognition it deserves to help us get our work
Read More
Ratings : 14 %
Read forum discussions about how to copy exact formula in excel (without changing reference) on Wall Street Oasis, the largest finance industry social network and web
Read More
Ratings : 74 %
Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria :
Ratings : 68 %
Extract Text from cells in Excel - How to get any word from a cell in Excel :
Ratings : 57 %
FIND() LEN() LEFT() RIGHT() Functions Extract Text From Cells in Excel Advanced P.1 :
Ratings : 32 %
hi, i want to add to the current value of a cell by direct entry. ie current value = 4 so when i enter 2 current value = 6 is there a way to do this in excel 2000?
Read More
Ratings : 28 %
One small point of emphasis I'll add to all the excellent answers given above: Probably the biggest thing you can do to avoid using Select is to as much as possible
Read More
Ratings : 40 %
Excel Magic Trick 1093: Extract Date from Middle of Description: Text To Columns or Formula? :
Ratings : 18 %
Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula :
Ratings : 11 %
Excel Magic Trick 706: Extract Number From Cell With A Time, A Dash and A Number :
Ratings : 41 %
Strategy: There is an optional third argument in the FIND function. This tells Excel to start looking after a certain character position in the text.
Read More
Ratings : 11 %
Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates :
Ratings : 66 %
Excel Magic Trick 1044: Formula To Extract & Sort Unique List Of Numbers Contains Empty Cells & Text :
Ratings : 35 %
Mr Excel & excelisfun Trick 140: Extract Text From Cell: Flash Fill, Formula or VBA? :
Ratings : 38 %
FIND() LEN() LEFT() RIGHT() Functions Advanced Extract Text From Cells in Excel P.2 :
Ratings : 69 %