Let’s say I have two columns. Both contain numbers.
First column could have either 111 or 222 as a value in each cell.
Second Column contains either a 1, 2, or 3 digit number. It could be 1. It could be 11. It could be 111. It could be any one, two or three digit number. (actually, it’s a specific number for each row, but that’s probably moot)
Is there a fast and easy way to merge the data between the columns? I want the resulting data to be, for instance, 222*11. The asterisk would be for formatting, not for multiplication
I don’t even really know if this is a well-written enough question to get the info to you all that I need.