|
|
#1
12-19-2016, 02:04 PM
|
|||
|
|||
How to use if condition to for this ...
How to write a function like below:
=IF(LEFT(A1,1)="4","",A1) Instead of 4, I would like to say, if its is an Alphabet (A-Z) For second to get numbers .... Instead of 4, I would like to say here, if its is a Number (0-9) Because I have to segregate it based on first character of a cell. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How can I sum values using SumIfs condition like ...
|
LearnerExcel | Excel | 6 | 11-28-2016 09:45 PM |
|
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)
|
SoonerLater | Mail Merge | 1 | 09-30-2015 05:40 PM |
|
Find and replace condition
|
norgro | Word VBA | 2 | 07-31-2015 06:38 AM |
|
check with condition
|
karti | Word | 2 | 03-15-2011 06:06 AM |
| Retrict Method Condition | markp | Outlook | 0 | 12-22-2005 05:38 PM |
Windows 7 32bit 
Office 2003
Threaded Mode