excel_help_ekka_ona

hansakach

Well-known member
  • Sep 17, 2006
    812
    36
    48
    Some where on the cyberspace
    mata tiyanva collam ekaka numbers vagayak
    00001
    00002
    00088
    00088*1
    00110*1
    00112
    00112*1
    00192
    00205
    00205*1

    meva ye * passe tiyana ilakkama ainkaranna ona
    00088*1 to 00088
    like this.
    danna kauru hari innavada formula ekkak...
    loku udavvak.....
     

    prabuddha2012

    Active member
  • Jan 15, 2013
    625
    134
    43
    mata tiyanva collam ekaka numbers vagayak
    00001
    00002
    00088
    00088*1
    00110*1
    00112
    00112*1
    00192
    00205
    00205*1

    meva ye * passe tiyana ilakkama ainkaranna ona
    00088*1 to 00088
    like this.
    danna kauru hari innavada formula ekkak...
    loku udavvak.....

    give me your email,
    i ll send how to do it
     

    mrcell

    Member
    Mar 1, 2011
    54
    4
    0
    Solution!

    assuming that your numbers are in Cell A1,

    copy & past this formula in B1

    =IF(ISERROR(FIND("*",A1,1)),A1,FIND("*",A1,1))
     

    laka007

    Well-known member
  • Oct 18, 2008
    7,490
    5,670
    113
    1 select karanna one data tik
    Data tab eke data tool wala text to columns
    select Delimited
    unclick all and click other and type *
    finished
     

    ryandok

    Well-known member
  • Oct 11, 2011
    13,684
    1
    3,802
    113
    වලපල්ලේ
    හැම එකේම 1 ද තියෙන්නේ ? * ට කලින් තියෙන ඉලක්කන් ගාන හැම කොලම් එකේම සමානද ?
     

    mrcell

    Member
    Mar 1, 2011
    54
    4
    0
    This should work


    mekat vada naha :(

    000000014
    000000014*1
    000000014*2

    me vage evata ena result eka

    000000014
    10
    10

    meka :(

    Sorry I have sent without checking:baffled:, try below, this should work:yes:.

    =IF(ISERROR(FIND("*",A1,1)),A1,MID(A1,1,FIND("*",A1,1)-1))
     

    LOL_SEEN

    Member
    Jul 21, 2016
    8,279
    712
    0
    Since formula already provided, no need to talk about formula.

    But in some cases no need to develop formulas and which take more time. In this case try Data Validation Tools . It is the easiest way.
     

    Mr.Tom

    Well-known member
  • Mar 1, 2013
    18,349
    3,725
    113
    EK Automobile
    ඔය ගනං ටික තියන්නේ A කොළම් එකේ නම් උත්තරේ ගන්න ඕනෙ සමාන්තර සෙල් එකේ =LEFT(A1,5) කියන ෆන්ෂන් එක ලියන්න. එතකොට එකක උත්තරේ ලැබෙයි. දැන් ෆන්ෂන් එක ලියපු සෙල් එක පහළට කොපි කරන්න.