How can I remove all blank spaces per line from either Excel and/or Notepad , without merging all l-CodePudding

First post here on stackoverflow, tried to search across the web but couldn't find the solution. If the question has already been answered, sorry!

I'm trying to do the following in either or both Excel and Notepad :

Text Example:

1 2 3
1  2  3
1   2   3

Desired Output:

123
123
123

I've looked at several solutions and the below example is not what I am looking for:

123123123

• Formula used in cell A7

=--BYROW($A$2:$G$4,LAMBDA(a,TEXTJOIN("",1,a)))

Formula applicable to MS365 this will spill, so you don,t have to drag!

Also if you are in MS365 and when writing this formulas if you have enabled Beta Channel from Office Insiders, then

• Formula used in cell B7

=CONCAT(TOROW(A2:G2,3,1))*1

• Formula used in cell C7

=CONCAT(TOCOL(A2:G2,3,1)) 0