Rang selection
Closed
Mahfuz
-
Jul 1, 2009 at 10:43 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 01:40 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 01:40 AM
Related:
- Rang selection
- How to make a selection in photoshop - Guide
- Print screen excel selection - Guide
- Iphone 15 network selection - Guide
- Atif aslam main rang sharbaton ka ✓ - Viruses & Security Forum
- Scene selection has been changed ✓ - Laptop Forum
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jul 2, 2009 at 01:40 AM
Jul 2, 2009 at 01:40 AM
I am not an expert in Macro but can give you suggestion by using work sheet function, if you like .....
Suppose you have data in A1 now in B1 you can write below formula
=IF(ISBLANK(A1),"N/A",IF(ISNUMBER(A1),-1,IF(ISTEXT(A1),A1,"")))
After this you can drag it down and by using paste special just paste values in column A .......
Suppose you have data in A1 now in B1 you can write below formula
=IF(ISBLANK(A1),"N/A",IF(ISNUMBER(A1),-1,IF(ISTEXT(A1),A1,"")))
After this you can drag it down and by using paste special just paste values in column A .......