Separate Text & Numbers

@VaibhavJ (Believe!! Live your dreams!)   (33501 Points)

28 October 2013  

Hi

 

Using UDF (user defined function) to separate Text & Number from excel cell.

 

Syntex is :

=GetNum(A1) for separating Number

&

=GetTxt(A1) for separating Text.

 

Here A1 refers to cell which is holding data. Please refer attached file.

 

Thanks//VaibhavJ