Copy cell value to new cell and exclude all spaces in process

I need to concat the value of 4 different cells in the same row. In the process, I need to remove all spaces in the calculated cells. The only requirement is I need to leave the original data intact and, if possible, use the existing code, but with modifications. Thanks

For example, 4 cells as follows:

A2 = 123456
C2 = LE MANS
D2 = 410 STREET
F2 = 789

The concat of G2 would be (including "|" to seperate each cell):
G2 = 123456|LEMANS|410STREET|789

Small sample attached if needed.

Please Login or Register  to view this content.

Maybe try this:

Please Login or Register  to view this content.

abousetta