Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2012, 11:17 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Default How to obtain the column “C” from column “A” and “B”?

How to obtain the column “C” from column “A” and “B”?
I couldn’t write a formula to obtain a new column that sticks the values of the two columns (A and B) but separated by a comma as shown in the attached screenshot.



Which formula should I write in column “C” to obtain the values of the column A and the column B separated by a comma

Thank you for the help
Regards
Jamal
Attached Images
File Type: jpg Clip_313.jpg (64.9 KB, 13 views)
Reply With Quote
  #2  
Old 02-26-2012, 12:18 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Try =A2&","&B2
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-26-2012, 01:28 PM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Thumbs up

Quote:
Originally Posted by Pecoflyer View Post
Try =A2&","&B2
Thank you for the answer. This is very helpful
All the best
Jamal
Attached Images
File Type: jpg Clip_316.jpg (52.0 KB, 12 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
i want add D Column in excel gsrikanth Excel 8 12-30-2011 06:11 AM
overallocated column ketanco Project 3 12-26-2011 09:26 AM
Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM
Column width markg67 Word 2 06-07-2010 07:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft