| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Micro or Function???
ir 660
250 350 700 ar 987 320 710 I am trying to create a macro or find a formula that would replace the text values in the first columns with the numerical values to their right. Please help. Thank you, Diana. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Micro or Function???
=if(istext(A1),b1,A1) and fill down to the end of your range.
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Diana" wrote: ir 660 250 350 700 ar 987 320 710 I am trying to create a macro or find a formula that would replace the text values in the first columns with the numerical values to their right. Please help. Thank you, Diana. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Micro or Function???
Thank you so much! All I need to know is where to post the formula and I
tried to fill it down but I think i'm doing it wrong. One more hint please? :) "Dave F" wrote: =if(istext(A1),b1,A1) and fill down to the end of your range. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Diana" wrote: ir 660 250 350 700 ar 987 320 710 I am trying to create a macro or find a formula that would replace the text values in the first columns with the numerical values to their right. Please help. Thank you, Diana. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i run a micro from a formula | Excel Discussion (Misc queries) | |||
| i would like to know how to remove or delete something from micro | New Users to Excel | |||
| help with micro excel please | Excel Discussion (Misc queries) | |||
| Micro | Excel Worksheet Functions | |||
| what does the micro do | New Users to Excel | |||
Linear Mode
