Merge Cells without leading SPACE?

[FunKPunK]

Hi all

I have data within a CSV and require to merge the last 4 cells of each line. This I can do fine at the moment, however, Calc merges them with a leading SPACE for each cell and i need this removed. Does anyone know if this is possible?

The CSV is for importing into Joomla/Virtuemart and the SPACE is breaking the download reference

Thanks

Stephen

[keme]

The TRIM() function wil remove leading and trailing spaces, but that will remove excess whitespace within the data too, which in some cases may be undesirable. If it's for URLs it should not be a problem, though.

[acknak]

Just use a formula* to concatenate them in a new column, then copy/paste special and paste only text (not formulas). It's not automatic, but it's not hard either.

*
=M1 & N1 & O1 & P1, or =CONCATENATE(M1; N1; O1; P1)

[Dave]

I have data within a CSV and require to merge the last 4 cells of each line.

Windows? Consider using freeware CSVed.

David.