Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2020, 07:14 PM
Marcia's Avatar
Marcia Marcia is offline Remove delimiters in merged columns in power query when null Windows 7 32bit Remove delimiters in merged columns in power query when null Office 2013
Expert
Remove delimiters in merged columns in power query when null
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Remove delimiters in merged columns in power query when null


Maybe I am looking for the wrong keywords. I have merged several columns in power query with comma and space as the custom delimiters. Some of the source columns were blanks and the resulting merged column showed several commas and spaces. I tried clean and trim but the pesky commas and spaces remain. How do I remove those extra commas and spaces?
Thank you.
Reply With Quote
  #2  
Old 11-06-2020, 08:05 PM
Purfleet Purfleet is offline Remove delimiters in merged columns in power query when null Windows 10 Remove delimiters in merged columns in power query when null Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

can you upload an example we can play with?
Reply With Quote
  #3  
Old 11-06-2020, 09:42 PM
Marcia's Avatar
Marcia Marcia is offline Remove delimiters in merged columns in power query when null Windows 7 32bit Remove delimiters in merged columns in power query when null Office 2013
Expert
Remove delimiters in merged columns in power query when null
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

I just found out that the commas appear in blank, not null cells. How do we force query to treat all blank cells as null?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove delimiters in merged columns in power query when null Format numbers in Power Query Marcia Excel 2 09-21-2020 12:59 AM
Power Query to combine multiple tables of unequal number of columns ProudLiberal Excel 1 01-07-2020 07:54 PM
Do I need a power query for this one? shabbaranks Excel 5 04-10-2019 03:29 AM
Issues Using Power Query file in Excel 2016 and then in 2013 bld9936 Excel Programming 0 02-27-2017 12:50 PM
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 AM.


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