Scenario: Here is a scenario that I have come across recently in Excel. I have the data in column that is split across multiple lines in each cell, more technically speaking, separated by carriage returns. i.e., the text in the cell is separated by pressing ALT + ENTER. see the below screenshot: Challenge: Now the... Continue Reading →
Microsoft Excel behaves strange when tried to replace or remove asterisk (*). Why..?
Here I came across a scenario of Microsoft Excel behaving strange, when trying to find and replace asterisk character (*) with another character. Scenario: Here is a list of data in an excel worksheet containing some fictitious data of names and salaries of a few employees. You can see that some of the names are containing an asterisk... Continue Reading →