Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

I need to output an alphanumeric answer

0

OK I am attempting to output an answer in a spreadsheet that will give me the following:

1A6

I have three separate columns that I have both numbers and/or letters and I need to output the example as above in a 4th column. 

Answer
Discuss

Answers

1

Assuming your 3 columns are A, B and C and you're picking up the entire cell not just a portion of it, the straight-forward =A1&B1&C1 should do it.

Discuss

Discussion

You beat me by 2 minutes hahah
don (rep: 1989) Jan 8, '19 at 11:17 am
It's always fun to see there are more than one way to do the same thing.

I'm too lazy to even bother with "CONCAT" and the brackets. Hahaha.
Cathy (rep: 53) Jan 8, '19 at 11:29 am
I am sorry but I am not getting anything with the  =A1&B1&C1 in the cell I need it to display in. I had tried this before now but have been stumped which is why I was asking.
coachwill Jan 8, '19 at 11:37 am
Add to Discussion
-1

If Column A has the 1 and Column B has the A and Column C has the 6, you would use a function like this:

=CONCAT(A1,B1,C1)

To add more cells, just type a comma in the function and select another cell.

Discuss

Discussion

Ok I tried this function before but I don't get a visible answer in the spreadsheet...It should display in the cell I enter the formula in correct?
coachwill Jan 8, '19 at 11:36 am
Yes. It seems like you have something else going on in the spreadsheet or maybe the cell references are off. If you edit your Quesion and attach a sample worksheet, we can quickly see the issue and better help.
don (rep: 1989) Jan 8, '19 at 12:39 pm
Cathy's answer is not different from Don's. Therefore Don's answer is a plagiate, doing the same thing in different syntax, and that is why I voted it down. The problem isn't in the syntax of the answer, however, it's in the question. coachwell never said that he has three cells containing "1", "A" and "6". Until he does the fact that the obviously correct solution doesn't work for him isn't a mystery. On the other hand, if coachwell really does have such 3 cells, the mystery can only be resolved by looking at his workbook. Please append one to your question.
Variatus (rep: 4889) Jan 8, '19 at 7:26 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login