when i use this code =SUBSTITUTE(A2," ","") it's one by one we can close the space. but, we can't able to do some bulk space. how to bulk space in excel ?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to close the bulk space ?
0
Answers
0
Hi Balaraj and welcome to the Forum
If you want to remove the spaces (or -more normally- double spaces or some other characters) from a column of cells (e.g. A2:A12), you can use an array function... Enter this in B2 (say):
=SUBSTITUTE(A2:A12," ","")If you want all those cells combined in one cell, use this in C2 say:
=CONCAT(B2:B12)If you mean rather how do we permanently remove all spaces from existing cells in a worksheet (or a selected range in one) say, don't use a formula but use Find and Replace (under the magnifying glass symbol, within the Editting section of the Home ribbon).
Hope this helps.