View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Inserting Additional Text in Spreadsheet

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?