| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Question
How do I put this into an excel formula ?
If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)" otherwise Y3&MID(N3;6;3) Thank you in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Question
Can't really check this without knowing what your data looks like but see if
this works. =IF(MID(N3,6,3)="OLA",MID(N3,6,3)&LEFT(N3,3),Y3&MI D(N3,6,3)) "carl" wrote: How do I put this into an excel formula ? If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)" otherwise Y3&MID(N3;6;3) Thank you in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Question
=IF(MID(N3;6;3)="OLA",MID(N3;6;3)&LEFT(N3;3),Y3&MI D(N3;6;3))
"carl" wrote: How do I put this into an excel formula ? If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)" otherwise Y3&MID(N3;6;3) Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Hybrid Mode
