Please assist me for delete the data....

[sampath]

Hi,

I have en number of data in excel. Keep the particular data from huge data in every row.


In column A, using "RIGHT" function. Need Output as "G"column from "A"column.

kindly assist me for the same.

Thank with regards,
Sampath.S

 

[Asheesh]

Suppose your data is in A2 (Input)...put the below formula in column G as per the image attached... and drag it down as you deem fit..

IF(A2=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",99),2),99)),"",TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",99),2),99)))

 

[sampath]

Hello Asheesh,

Thanks for your assistance. It 's working like my expatiation.

Regards,
Sampath.S

 

[Asheesh]

You welcome...happy to help..

 

[Khalid NGO]

Hi Sampath,

Asheesh given you v.good ans, here is another one:
If the max length of your data = 14
you can go with this simple one:

=IF(LEN(A2)=14,RIGHT(A2,2),"")

Regards,