Jump to content

Recommended Posts

Posted

Column A 

1.23

2.83

.

.

8.9

.

7.6

 

Ila chala columns unay. Ipudu only . unna cell ni 0 tho replace cheyali ante ela? Replace . with 0 chesthe values unna cells kuda maripothunay, for ex 1.23 1023 ga maripothundi.

 

Google lo kodadam ante em kottalo ardam kaka ikada vesa. koncham chepandi vay..

Posted

Ctrl+F kotti replace tab ki velli

options select chesi

match entire cell contents check cheyyi

find  what lo . ani kottu

replace with lo 0 ani kottu

find next kottukuni check chesukoo replace chesi check chesukooo 2 3 cells

 

work aithe replace all kotteseyyi

  • Upvote 1
Posted

Ctrl+F kotti replace tab ki velli

options select chesi

match entire cell contents check cheyyi

find  what lo . ani kottu

replace with lo 0 ani kottu

find next kottukuni check chesukoo replace chesi check chesukooo 2 3 cells

 

work aithe replace all kotteseyyi

 

 

2nktl5f.jpg

 

 

I hope this helps :)

  • Upvote 1
Posted

Ctrl+F kotti replace tab ki velli

options select chesi

match entire cell contents check cheyyi

find  what lo . ani kottu

replace with lo 0 ani kottu

find next kottukuni check chesukoo replace chesi check chesukooo 2 3 cells

 

work aithe replace all kotteseyyi

 

 

2nktl5f.jpg

 

 

I hope this helps :)

 

 

 

Aha work iyindi.. Anduke I love DB.. Evaro okaru help chestaru... Thanks Bayya

×
×
  • Create New...