LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default how can i insert a word into many cells in a list

I have a list of words, say 40 or so, and I want to insert one word into each
cell, which is the same word, without typing that word into each cell. is
there some way of doing this? The word will go before or after the word in
the list, not in the middle of it.

I searched for a prefix formula but seem to have come to a dead end.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a formula to 'find' word in cells of column from a long list Deden Excel Worksheet Functions 10 November 26th 08 02:30 AM
List of cells that contain a particular word cloudyMalta Excel Worksheet Functions 3 May 29th 08 02:35 PM
Insert letter/no among word ShamsulZ Excel Discussion (Misc queries) 2 October 5th 06 10:39 AM
importing list with commas from WORD, to individual .xls cells? brantty Excel Discussion (Misc queries) 1 August 5th 05 12:31 AM
=SUM Then insert word. iwgunter Excel Worksheet Functions 3 November 1st 04 10:13 AM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"