Concatenating values from two columns with 20 spaces between them

milealek

Hi guys,

I have a task to concatenate two strings from two different columns with formula. The values are for example SEA129 and 01.

What I want to achieve is a string which will look like this "SEA129 (20 blank spaces) 01"

Has anybody encountered similar issue?

Paul Newcome

You can accomplish this on the back-end as having those 20 spaces stored, but the cell will only show a single space.

=[Column 1]@row + " insert your 20 spaces here " + [Column 2]@row

Does it have to be spaces? Why 20?

Paul Newcome

You can accomplish this on the back-end as having those 20 spaces stored, but the cell will only show a single space.

=[Column 1]@row + " insert your 20 spaces here " + [Column 2]@row

Does it have to be spaces? Why 20?

milealek

Thanks, nice tip. It turned out that it's indeed stored, and when I export it to file, the spaces show :D Thank you! That's what I needed!