I am trying to copy info from a cell into a new cell, and I would like help with prepending the newly populated cell with text. here is my thought on how it should work, but it doesnt.
GIVEN
A1 = 365
then my thought was formula should look something like this -
A2=("PO BOX", A1)
giving me a new value of PO BOX 365
PO.png
Thanks in advance!
Bookmarks