Forum Discussion
adding a space and text to words in excel cells...
Hi guys - I have a list of stock tickers between 3 and 5 letters... I need to amend these so each one has a 'space' followed by the letters 'US' For example - the list would be ABB, BP, NGLOY but...
This solution is specific to Excel 365 and moves the calculation to a Lambda function. That does have a potential advantage that the same function may be applied to several lists if required.
"Worksheet formula"
= BYROW(ticker, CSV.USλ)
"CSV.USλ"
= TEXTJOIN(",", , TEXTSPLIT(v, ",") & " US")
