How to get first characters or numbers from the value

In Excel there is a simple function LEFT, which is used to get first characters of value or to remove unwanted characters from the right side. Continue reading “How to get first characters or numbers from the value” »

How to split the value

In this article I want to show the possibilities of splitting values to the multiple parts. There are several ways how to do it. It depends on the value you want to split. I will show you how to use Text to Columns and text functions LEFT, RIGHT, FIND, LEN. Continue reading “How to split the value” »

Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress