Solved

Concatenate values within the same cell & space

Forum|Forum|1 year ago
March 13, 2024
4 replies
80 views

+20

galigis
Enthusiast

Hi All,

I need to concatenate the two values of the same cell into just one line. I’ve been (partially) able to do it by using a StringReplacer but some of the cells show an space which make the StringReplacer not working, see below an example:

There’s an space between line 2 and Siding, how can I make the final result ‘CE Siding’ ?

Best answer by nielsgerrits

Thanks @nielsgerrits but still doesn’t do what I need, see below the parameters used:

The value at row 6 still shows an space between 2 and Siding

Try to copy the value you need to replace and paste it in the StringReplacer, no regex?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.