Thread
:
Prefix
View Single Post
#
2
Andy Brown
Posts: n/a
"Big Boss" <Big
wrote in message
...
How do I prefix a character to all all the filled in cells in a column
To do this with a formula, use e.g.
=IF(A1<"","X"&A1,"")
in a spare column and drag it down.
If you want to go on to replace the originals, copy the formulas, then use
Edit -- Paste Special -- Values.
Reply With Quote