Excel

[gayanwin]

ABC(NW)/OK/SER/OK/KURU/2000/20 - Computer School (Fund Transfer) - 09211 / 678 / 1

Uda Data Tiak Machan Excel eka cell ekaka thiyenne Red Color walin Highlight Karapu Num tika Witharak Ithuru Wenan ANik Tika Remove Karanne Khmada

 

[thaweesha]

Data to column dala - eken kadanna. Itapasse anthima column eka ganna.

 

[The_Killer]

deleted

 

[krizta]

=RIGHT(Cell,Characters)

=RIGHT(D562,17))

 

[EKGuest]

=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",LEN(A1))),LEN(A1)))