Manoj Chaurasia Posted April 9, 2022 Share Posted April 9, 2022 Concatenate([A_Name],":",[b_Name]) Link to comment Share on other sites More sharing options...
Gaia Paolini Posted April 12, 2022 Share Posted April 12, 2022 using your Concatenate formula on two columns did not result in an added space. Can you give more details Link to comment Share on other sites More sharing options...
Jose Leviaguirre Posted April 12, 2022 Share Posted April 12, 2022 if your data contains space, you can remove them by using the trim function. The trim function removes whitespace from the beginning and end of a string. Example: Trim(" Example ") with that, you can nest your concatenate function like this: Concatenate(trim([A_Name]),":",trim([b_Name])) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now