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.

concatenate(a1,"*",a2)

God bless you.

=concatenate(a1,"*",a2)

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.