Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcards and if
I don't know how to explain let alone set this up. I have some information
from a database that relates to a separate database. I need to cojoin the information in excel. The problem is the first information needs to have the common field changed. It was entered as 0545 and should have been O545, and there is more than one group like this. I need to say something like this =if(A5=0*,O*,A5) I know this doesn't even come close to the solution, but what I am trying to do is set up another column that changes the particular fields that are a problem, they are not all a problem so must just change some. I don't even know if excel will change the 0 to an O and keep the rest of the field. It's sort of like an update in Access. Does anyone know if it can be done? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcards and if
=IF(LEFT(A1,1)="0","O"&MID(A1,2,99),A1)
"Arlene" wrote: I don't know how to explain let alone set this up. I have some information from a database that relates to a separate database. I need to cojoin the information in excel. The problem is the first information needs to have the common field changed. It was entered as 0545 and should have been O545, and there is more than one group like this. I need to say something like this =if(A5=0*,O*,A5) I know this doesn't even come close to the solution, but what I am trying to do is set up another column that changes the particular fields that are a problem, they are not all a problem so must just change some. I don't even know if excel will change the 0 to an O and keep the rest of the field. It's sort of like an update in Access. Does anyone know if it can be done? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcards and if
But if the 0545 were treated by Excel as a number, rather than as text, then
it wouldn't store it as 0545 but as 545, so the formula wouldn't work. If the 0545 were intserted as text, it would work. -- David Biddulph "Teethless mama" wrote in message ... =IF(LEFT(A1,1)="0","O"&MID(A1,2,99),A1) "Arlene" wrote: I don't know how to explain let alone set this up. I have some information from a database that relates to a separate database. I need to cojoin the information in excel. The problem is the first information needs to have the common field changed. It was entered as 0545 and should have been O545, and there is more than one group like this. I need to say something like this =if(A5=0*,O*,A5) I know this doesn't even come close to the solution, but what I am trying to do is set up another column that changes the particular fields that are a problem, they are not all a problem so must just change some. I don't even know if excel will change the 0 to an O and keep the rest of the field. It's sort of like an update in Access. Does anyone know if it can be done? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcards and if
Thank you mama; it seems so simple when you know how.
"Teethless mama" wrote: =IF(LEFT(A1,1)="0","O"&MID(A1,2,99),A1) "Arlene" wrote: I don't know how to explain let alone set this up. I have some information from a database that relates to a separate database. I need to cojoin the information in excel. The problem is the first information needs to have the common field changed. It was entered as 0545 and should have been O545, and there is more than one group like this. I need to say something like this =if(A5=0*,O*,A5) I know this doesn't even come close to the solution, but what I am trying to do is set up another column that changes the particular fields that are a problem, they are not all a problem so must just change some. I don't even know if excel will change the 0 to an O and keep the rest of the field. It's sort of like an update in Access. Does anyone know if it can be done? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use of wildcards | Excel Worksheet Functions | |||
Wildcards in RTD | Excel Discussion (Misc queries) | |||
Use wildcards | Excel Discussion (Misc queries) | |||
wildcards in vba | Excel Discussion (Misc queries) | |||
VBA Wildcards - HELP! | Charts and Charting in Excel |