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...
=REPLACE(SUBSTITUTE(A1,","," US,"),LEN(SUBSTITUTE(A1,","," US,"))+1,3," US")
Does this formula return the intended result?
