| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TEXT issues
The following is the Row of codes that states like INVMP etc.
How can I formulate in a cell to tell me that when the code row is a text, give me result 'Clearance' For example Cell A2 is shown as "INVMP". A formula that states results in cell A1 'Clearance' and if A2 is blank, it will show as blank and if A2 is a numeric e.g. 12222 and result in A2 will show as 12222. Code INVMP INVMP INVTT INVTA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TEXT issues
hi
i may be a little confused but try this and see if it is what you want.... =IF(A2="","",IF(ISTEXT(A2),"Clearence",A2)) regards FSt1 "Jafferi" wrote: The following is the Row of codes that states like INVMP etc. How can I formulate in a cell to tell me that when the code row is a text, give me result 'Clearance' For example Cell A2 is shown as "INVMP". A formula that states results in cell A1 'Clearance' and if A2 is blank, it will show as blank and if A2 is a numeric e.g. 12222 and result in A2 will show as 12222. Code INVMP INVMP INVTT INVTA |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TEXT issues
FSt1.. THANK YOU VERY MUCH! This helps
"FSt1" wrote: hi i may be a little confused but try this and see if it is what you want.... =IF(A2="","",IF(ISTEXT(A2),"Clearence",A2)) regards FSt1 "Jafferi" wrote: The following is the Row of codes that states like INVMP etc. How can I formulate in a cell to tell me that when the code row is a text, give me result 'Clearance' For example Cell A2 is shown as "INVMP". A formula that states results in cell A1 'Clearance' and if A2 is blank, it will show as blank and if A2 is a numeric e.g. 12222 and result in A2 will show as 12222. Code INVMP INVMP INVTT INVTA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart and text box issues | Charts and Charting in Excel | |||
| Text alignment issues in Excel 2007 | Excel Discussion (Misc queries) | |||
| Issues with white space when printing & with wrapping text | Excel Discussion (Misc queries) | |||
| Issues with saving text file | Excel Worksheet Functions | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
![Jafferi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
