Announcements
Ok. What I want is to input a string, for example "1234AB5678" and have it output as "A-1234AB5678". This seems like it should be simple but I'm having a heck of a time with it. Can anyone point me in the right direction?
Edit: Nevermind, it's a simple Concatenate function.
Hi
Does the conversion have any formula or rule? Or do you want just to add 'A-' behing the input?
@Anonymous
So just to clarify the answer for anyone else reading this, the formula would be:
Concatenate("A-", "1234AB5678")
or alternatively, this would work too:
"A-" & "1234AB5678"
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 360 Super User 2026 Season 2
M Bilal Khan 325
Mohsin Ali 232