Tags: RIGHT

Remove abbreviations appearing before a name

{ 2 Comments }

Assume there is a list of names appearing in range A2:A9.  Before these names, there are abbreviations such as Dr., Mr. Mrs. etc.  To worsen the situation, there may/may not be a space after the abbreviation.  A sample dataset may look like this: Mr.Ramakrishna Mr Ramakrishna Mr. Ramakrishna MrRamakrishna PhD.Saurav Dr (Mrs.) Indu Sharma Dr. (Mr) […]

Read More →

Story telling with Excel Power BI

{ 6 Comments }

With Power Business Intelligence (BI) tools of Excel 2013, one can metamorphose raw data and/or results of complex calculations into stunning and interactive visualizations.  Power View (one of the four components of Power BI) allows one to create a PPT like flow in Excel thus allowing one to weave a story.  To be able to interact with/create visualizations, […]

Read More →

Worksheet formulas in a newly copied worksheet should point to the previous worksheet

{ 15 Comments }

Assume a worksheet with formulas referring to the previous worksheet.  When this sheet is copied by right clicking the sheet and selecting Move or Copy > Copy, formulas in this newly created sheet, should change to refer to the previous sheet. In other words, if sheet2 has formulas referring to sheet1, then when sheet3 is created (by […]

Read More →

Extract text from a custom formatted cell

{ 34 Comments }

In range G5:G44, some numbers are entered.  These numbers are custom formatted with General” Dr” for debit entries and General” Cr” for credit entries. One may want to extract the Dr and Cr in range H5:H44. The following process will get the desired result: 1. Press Ctrl+F3 > New and in the Name box, type […]

Read More →