Notes tests, string, manipulation of text files and string manipulations

[DocAElstein]

Some notes to go with this forum post
https://eileenslounge.com/viewtopic....314200#p314200
https://eileenslounge.com/viewtopic....314281#p314281

---

Just for fun, the way I might do it.
Same test data, just to help compare offered solutions:
https://i.postimg.cc/NjzZxy0C/Test-d...n-column-D.jpg
Test data 5 rows of columns A - C to be summed in column D.jpg

I want in column D the summed values and also the numbers used in the summation , - I want the numbers used in the summation, for example, for future reference even if I delete columns A - Z

I would do this …..

Sub My2Euros() '  https://www.excelfox.com/forum/showthread.php/2860-Notes-tests-string-manipulation-of-text-files-and-string-manipulations?p=23991&viewfull=1#post23991
 Let Selection = "=A1+B1+C1 & ""                     "" & A1 & "" "" & B1 & "" "" & C1"   '     This line is like putting this formula in cell D1    =A1+B1+C1 & "          " & A1 & " " & B1 & " " & C1         and dragging it down
 Let Selection = Selection.Value                                                          '     line changes the cell values to the value the formula gives, rather than the formula, ( this is necessary so that I can still everything as I initially do in the sum result column, even if I delete the columns A - C
End Sub

The first code line is like putting this formula in cell D1

=A1+B1+C1 & "                     " & A1 & " " & B1 & " " & C1

https://i.postimg.cc/wjvSJ59s/First-...1-A1-B1-C1.jpg
First code line is like this in D1 A1+B1+C1 & & A1 & & B1 & &.jpg
, and then dragging it down.

The second code line changes the cell values to the value the formula gives, rather than the formula, ( this is necessary so that I can still everything as I initially do in the sum result column, even if I delete the columns A - C


That way is just my preference for a few reasons:
_ Text and text storage in computers is, as I understand it as a computer Layman, cheap and easy these days, so having a lot of text anywhere idoes no noticeable harm or performance degradation
_ I would probably have things in the next column and my columns are not usually very wide., so I usually only see the results clearly, but if need be, to get full information ,I can extend the column , look in the formula bar or copy cells or a cell, etc.
https://i.postimg.cc/TPW36LNB/Extend...-full-info.jpg
Extended column or look in formula bar for full info.jpg