Occélus Orac
Last answered:

28 Mar 2024

 Posted on:

22 Mar 2024
0

Resolved: Working with text in Excel

in Introduction to Excel / Welcome to the Course

This is just a comment


I'd prefer write the last formula as below

=B5&", "&C5


We also have the TEXTJOIN function in current version of Excel which works perfectly for this kind of exercise: =TEXTJOIN(",",TRUE,B5,C5).

1 answers ( 1 marked as helpful)
Ned Krastev
Instructor
Posted on:

28 Mar 2024
0

Hey Occelus,

Sounds good. There are many ways to obtain the same result. As long as it works - feel free to stick to your preferred method.

Best,

Ned

Helpful answer

Submit an answer

related questions

Olisa Kizito Clement
2
20
Resolved: Error In Introduction to Excel Practice Exam 3
abiola Emili
0
12
Excel: Football Trnasfer Analysis
Saber Ahmad
2
10
The feature is not working
Samantha smith
1
8
Can anyone update this to the current version of Excel?
Quang Nguyen
0
6
Using Free Online version of Excel to Create a Bridge Chart
N P
1
6
Practice Exams don't work (Introduction to Excel)
Weiqiang Chung
0
6
Resolved: Issues with number stored as text
Obioha Chijioke
1
6
Using x's in excel to speed up copy and paste.