One way ..
Assuming source text running in A1 down
and you want to prefix* the text: XXX
*with a space after XXX
Put in B1: ="XXX "&A1
Copy down to B900
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SEBA Branch Inventory" wrote:
How do I add the same word to the start of 900 different text descriptions
globally without individually editing all 900 line items?