EXTRACT TEXT With LEN() and RIGHT() Function
Suppose you only want a specific text from a particular cell and avoid extra label like "Name:-" or whatever your database contain. To apply it and get the result you will have to follow the few step as mentioned below.
First find out the total length of the particular cell text by using =LEN(A2) formula and apply in next to name column OR you can directly apply into the LEN function like this =RIght(A2,LEN(A2)-7) NAME:- <------(7) character. .Remember it always depends on your criteria so apply according to your criteria baseNOTE: LEN() function count the space too.Follow the step shown in image and video provided below.
IMAGE EXAMPLE ONE :
IMAGE EXAMPLE TWO :