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>
<tbody>
</tbody><o> </o>
Thank you.<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>
Account (A)<o></o> | Combined GL (B)<o></o> | Cost_Center (C)<o></o> |
01-001-1-000-0000 Legislative Grants<o></o> | 01-001-1-000-0000-0 Legislative Grants<o></o> | 0<o></o> |
01-011-1-000-0062 Other Grants-Parents reac<o></o> | 01-011-1-000-0062-STM Other Grants - Parents reac<o></o> | STM<o></o> |
Thank you.<o></o>