Excel Guru, I'm calling you out! (help please)

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 :slight_smile:

I don’t even really know if this is a well-written enough question to get the info to you all that I need.


God bless you.


don’t ask,

You have just saved me hours and hours of data entry. Thank you SO much.

Your fiend,
Mr. Cynical

Moderator, this thread has served its due. Feel free to close.