excel_help_ekka_ona

[hansakach]

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]

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]

Solution!

assuming that your numbers are in Cell A1,

copy & past this formula in B1

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

 

[Munkey]

sort karala left paththe edan character count eken ganin..
real sample ekak dunnoth karala ewanna try ekak dennam

 

[prabuddha2012]

if your number in cell C7 FORMULA IS =LEFT(C7,"5")

00088*1 = 00088

 

[mousenote123]

*1 witarak nam thiyenne "Find and Replace" walin karala balanna.

 

[sanjeew1974]

If your value in cell address A1, type in Cell address B1 =LEFT(A1,5)

 

[laka007]

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

 

[hansakach]

assuming that your numbers are in Cell A1,

copy & past this formula in B1

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

mekat vada naha

000000014
000000014*1
000000014*2

me vage evata ena result eka

000000014
10
10

meka

 

[hansakach]

if your number in cell C7 FORMULA IS =LEFT(C7,"5")

00088*1 = 00088

mevidihat vada naha numbers 5 name eka venas venava..

 

[hansakach]

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

text eka number valata convert vela issaraha tiyana bindu tika natuva yanva.

 

[TeddyK]

Me link deke tiyena widiha try karapan :

Option 1 = text to column

https://support.office.com/en-us/ar...s-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

Option 2 = LEFT AND FIND

http://www.excelfunctions.net/split-string-in-excel.html

Puluwannam sample file ekak ewapan, solution eka quick wei !

 

[laka007]

text eka number valata convert vela issaraha tiyana bindu tika natuva yanva.

data thiya column eka select karala
right click
Format Cell
select TEXT
OK

 

[ryandok]

හැම එකේම 1 ද තියෙන්නේ ? * ට කලින් තියෙන ඉලක්කන් ගාන හැම කොලම් එකේම සමානද ?

 

[mrcell]

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, try below, this should work.

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

 

[LOL_SEEN]

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]

ඔය ගනං ටික තියන්නේ A කොළම් එකේ නම් උත්තරේ ගන්න ඕනෙ සමාන්තර සෙල් එකේ =LEFT(A1,5) කියන ෆන්ෂන් එක ලියන්න. එතකොට එකක උත්තරේ ලැබෙයි. දැන් ෆන්ෂන් එක ලියපු සෙල් එක පහළට කොපි කරන්න.