Question description:
This user has given permission to use the problem statement for this
blog.
I have numbers in two separate columns in excel and was wondering if it is possible to add the second column up and put this in brackets alongside the numbers in the first column into a third colum as per below
Column A
19
Column B
5
Column C to show as:
19(5)
Not sure if this is possible or not in exel?
Many Thanks
Solved by K. C. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
21/03/2018 - 06:58
hi
Excelchat Expert
21/03/2018 - 06:58
hi there!
User
21/03/2018 - 06:58
Was hoping you could answer my query please
Excelchat Expert
21/03/2018 - 06:58
I'm certain I can help you with your Excel formula!
Excelchat Expert
21/03/2018 - 06:58
do you have the sheet shared in the Google Sheet window?
User
21/03/2018 - 06:59
I don't, I am currently using Excel 2016
Excelchat Expert
21/03/2018 - 06:59
actually... we can just do it here and you can copy the formula
Excelchat Expert
21/03/2018 - 06:59
so check out the window - let me know if this is the initial setup
Excelchat Expert
21/03/2018 - 06:59
and column C needs to show "19(5)
Excelchat Expert
21/03/2018 - 06:59
is that correct?
User
21/03/2018 - 06:59
Yes please
Excelchat Expert
21/03/2018 - 07:00
awesome
Excelchat Expert
21/03/2018 - 07:00
so check this out
Excelchat Expert
21/03/2018 - 07:00
you can copy that formula in cell C1
Excelchat Expert
21/03/2018 - 07:00
and paste it in your Excel file and let me know if it works for you.
User
21/03/2018 - 07:01
Ok will try that now thanks
Excelchat Expert
21/03/2018 - 07:01
my pleasure sounds good
User
21/03/2018 - 07:02
Yes that has worked in my excel :)
Excelchat Expert
21/03/2018 - 07:02
woohoo!
Excelchat Expert
21/03/2018 - 07:03
ping us if you need further assistance - we are here to help!
Excelchat Expert
21/03/2018 - 07:03
have a great rest of the day
User
21/03/2018 - 07:03
Thanks very much, I was sure it was possible was just not sure how to do it
Excelchat Expert
21/03/2018 - 07:03
now you know :)
User
21/03/2018 - 07:03
Very much appreciated :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.