Use Vba To Join Cell Values With Either & Or Concatenate Formula
2 minute read Join multiple string cells using one of 2 options, the code below shows how to choose the two, it boils down to what the user finds easier to read. =CONCATENATE(A1,” “,B1,” “,C1) or =A1&” “&B1&” “&C1 note: Concatenate formula limitations, 255 string limit and & has none The code below uses the … Read more