Wednesday, March 30, 2016

Add Comma to separate cell values [Solved]

Add Comma to separate cell values

I have 327 text values in a column that I want to either export with a comma between them or use a function to do it.


I have:

and on.

I want to get it like this:

R-2025,R-2016,R-2030,R-3100 and on and on.

Solutions to the Problem Add Comma to separate cell values

Download SmartPCFixer to Fix It (Free)

I'm not sure where I enter this.
 I tried Insert Function...

My cell range is A2:A326

With your workbook open hit Alt + F11 to open VBE
View>Project Explorer then select your workbook and Insert>Module.  Paste the code into that module.
Alt + q to return to your sheet.  In B1 enter   =concatrange(a2:a326)
That's it.
BTW:  Ashish's method works fine.  Review the steps he posted and try again.

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Recommended Method to Repair the Problem: Add Comma to separate cell values:

How to Fix Add Comma to separate cell values with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.

Related: [Solved] Applications have stopped working with SP1 on Windows 7!,[Solved] I can't find auto complete text in word 2007,[Solution] I need to keep reinstalling eHome Infrared Transceiver driver everytime my computer shuts down.,How to Resolve - system restore not working windows 7?,Unable to open embedded word file on the intranet. [Solved],Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: [Solved] about software download, I am looking for the latest full version of adobe photoshop professional for free download,How to Fix - Active window becomes temporarily inactive disabling typing...It only lasts a second or two before it becomes active again and allows typing...?,Troubleshoot:a formula which reads \"whatever is in the cell above, but one column over\"...,How Can You Fix - Activation of Settings App and Error code 0x80246007?,Solution to Problem: A friend sent me an e-mail with just a link and am not able to view it.,Cannot delete empty file icon on desktop...,Cannot download flashplayer,can't get the CIA review progrom install which is an older version,Cannot access one website-DNS server not responding.,Can't Receive or Send Vista Windows Mail - Router stopped recognizing DSL connection & wants to dial up

No comments:

Post a Comment