Accountstep
New Member
- Joined
- Aug 31, 2010
- Messages
- 17
Hello,
Would you tell me how to do this formula, please?
I want to start the formula with the text of CORR DAR, then use a space and link it to another sheet call that has a short date format, then use a space, a dash, and then link it to the same linked sheet cell that has a text value.
e.g. This is the way they have the formula now:
=CONCATENATE("CORR DAR ",ENTRY!A2,"-",ENTRY!B2)
Where the linked sheet name is ENTRY.
The result they're getting in the JE sheet where the formula is is coming out like this:
CORR DAR 44621-715164
We want the result to be CORR DATE 3/1/2022 - 715164.
What is the proper formula, please?
Thank you!
Would you tell me how to do this formula, please?
I want to start the formula with the text of CORR DAR, then use a space and link it to another sheet call that has a short date format, then use a space, a dash, and then link it to the same linked sheet cell that has a text value.
e.g. This is the way they have the formula now:
=CONCATENATE("CORR DAR ",ENTRY!A2,"-",ENTRY!B2)
Where the linked sheet name is ENTRY.
The result they're getting in the JE sheet where the formula is is coming out like this:
CORR DAR 44621-715164
We want the result to be CORR DATE 3/1/2022 - 715164.
What is the proper formula, please?
Thank you!