Easy Office
LCI Learning

Separate Text & Numbers

Page no : 2

satya (Executive Excise) (1839 Points)
Replied 31 January 2014

Dear Vaibhav ji,

sorry to disturbing you,

it is not showing all missing numbers, I highlighted missing numbers not picked by program in another cell.

kindly do the needful.

P.S:SORRY TO DISTURBING YOUR VALUBALE TIME FOR ME


Attached File : 42215 1280069 112266 1279617 misslist.xls downloaded: 150 times


@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 31 January 2014

It was good excercise!

 

Thx, hope this is done.


Attached File : 112266 1280081 42215 1280069 112266 1279617 misslist.xls downloaded: 139 times
1 Like

satya (Executive Excise) (1839 Points)
Replied 31 January 2014

THANK YOU VERY MUCH VAIBHAV JI,

FINE IT IS WORKING

THANKS to CACLUBINDIA PLATFORM

THANK YOU................VAIBHAV JI

1 Like

Avdhoot (Finance Manager) (35 Points)
Replied 05 February 2014

Sir,

Formula =GETNUM() or =GETTXT()  is not working in my excel sheet. 


@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 05 February 2014

hi Avadhoot, Did you enabled macro?

 

If not enable macro & then try!

 

Thx




satya (Executive Excise) (1839 Points)
Replied 05 February 2014

Dear Sir,

first you install the below file in to your system, then try;

Hi   You can save file as .xla & its done.   Also file is attached herewith.   Thanks//VaibhavJ Attached File : 112266 1244569 separate text.xla downloaded 40 times

Read more at: /forum/details.asp?mod_id=269237&offset=1#.UvIIcWKSxe8


satya (Executive Excise) (1839 Points)
Replied 05 February 2014

VAIBHAV IS GREAT..........

1 Like

@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 05 February 2014

Originally posted by : sathya
VAIBHAV IS GREAT..........

hi sathya, its kind of you but i am also like all of us on CCI, it is knowledge gap which is getting helped thru CCI..

 

Cheers!!


Avdhoot (Finance Manager) (35 Points)
Replied 05 February 2014

Vaibhav Sir,

How can enable macro, pls guide

 

1 Like

@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 05 February 2014




Avdhoot (Finance Manager) (35 Points)
Replied 13 February 2014

Sir,

I want the sheet of billwise payment in excel sheet, can u give me....

 



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Join CCI Pro


Subscribe to the latest topics :

Search Forum: