Skip to main content
  • EN

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’ ?

 

 

StringReplacer, regex, replace \n

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 and also a Carrier Return

 

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?

It worked! :)

Reply


Community Stats

30,351
Posts
115,341
Replies
38,081
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.