Skip to main content

Posts

Showing posts from July, 2014

How to Disconnect Bsnl BroadBand and Landline Services Online

Most of the service providers and executives are experts in facilitating the procedures on how to avail the service but will keep their service termination procedures around the corner which will make it difficult for the users to switch on to other networks immediately and easily. Did you know there are people who rely on their faulty landline/broadband connection simply for the complex procedures and time it would take to close the faulty connection? But here in this blog, we have grabbed the termination process from around the hidden corners of the Bsnl portal to facilitate the Bsnl phone disconnection process in simple steps. Note: You can be an existing BSNL customer for years, however, it is mandatory to have an online account registered in the BSNL customer relationship management(CRM) self-care portal to access the online services. If you don't have one, create one by clicking on the below respective links to access your region Bsnl self-care portal for account mana

How to Split Excel Values into Two or More Columns Using Delimiter

Most of us are aware of the concatenation utility support provided in MS Excel to combine two cell fields values into one. Whereas how many of us are really aware of splitting the concatenated values from a specific field into two or more fields values. To achieve this scenario, like programming languages that use a separator called Delimiter to isolate different variables. Excel uses similar delimiter logic to separate the data values of excel cells into two or more values in different consecutive cells. Read Also: How to Highlight Excel Search word In colors of Choice Separate Excel Data Values of One Cell to Many Cells Just follow the below screenshot and explanation to achieve this split cells event in Microsoft Excel. Split Excel Values Into Several Columns Step: Select a column containing rows of data that have to be separated and then Go to Data -> Text to Columns. Select Values then Data - >Text to Column   Step:  Select Delimited and then cli