Hello,<o
></o
>
<o
> </o
>
I need to build a formula, which can combine two data from Aand C into B.<o
></o
>
Data in C can be from 0(zero) to ABSD (four letters).<o
></o
>
You can see in B how the result should look like.<o
></o
>
[TABLE="class: MsoNormalTable, width: 476"]
<tbody>[TR]
[TD="width: 350, bgcolor: transparent"] Account (A)<o
></o
>
[/TD]
[TD="width: 363, bgcolor: transparent"] Combined GL (B)<o
></o
>
[/TD]
[TD="width: 80, bgcolor: transparent"] Cost_Center (C)<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 350, bgcolor: transparent"] 01-001-1-000-0000 Legislative Grants<o
></o
>
[/TD]
[TD="width: 363, bgcolor: transparent"] 01-001-1-000-0000-0 Legislative Grants<o
></o
>
[/TD]
[TD="width: 80, bgcolor: transparent"] 0<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 350, bgcolor: transparent"] 01-011-1-000-0062 Other Grants-Parents reac<o
></o
>
[/TD]
[TD="width: 363, bgcolor: transparent"] 01-011-1-000-0062-STM Other Grants - Parents reac<o
></o
>
[/TD]
[TD="width: 80, bgcolor: transparent"] STM<o
></o
>
[/TD]
[/TR]
</tbody>[/TABLE]
<o
> </o
>
Thank you.<o
></o
>


<o


I need to build a formula, which can combine two data from Aand C into B.<o


Data in C can be from 0(zero) to ABSD (four letters).<o


You can see in B how the result should look like.<o


[TABLE="class: MsoNormalTable, width: 476"]
<tbody>[TR]
[TD="width: 350, bgcolor: transparent"] Account (A)<o


[/TD]
[TD="width: 363, bgcolor: transparent"] Combined GL (B)<o


[/TD]
[TD="width: 80, bgcolor: transparent"] Cost_Center (C)<o


[/TD]
[/TR]
[TR]
[TD="width: 350, bgcolor: transparent"] 01-001-1-000-0000 Legislative Grants<o


[/TD]
[TD="width: 363, bgcolor: transparent"] 01-001-1-000-0000-0 Legislative Grants<o


[/TD]
[TD="width: 80, bgcolor: transparent"] 0<o


[/TD]
[/TR]
[TR]
[TD="width: 350, bgcolor: transparent"] 01-011-1-000-0062 Other Grants-Parents reac<o


[/TD]
[TD="width: 363, bgcolor: transparent"] 01-011-1-000-0062-STM Other Grants - Parents reac<o


[/TD]
[TD="width: 80, bgcolor: transparent"] STM<o


[/TD]
[/TR]
</tbody>[/TABLE]
<o


Thank you.<o

