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.