Inserting a string of text in front of existing text in excel

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

How do I insert a word or words in front of existing text
cells on a multiple cell basis ?
 
Hi
try something like the following macro (works on your
selection):
sub foo()
dim rng as range
dim cell as range
dim str_part
set rng=selection
str_part="precede_"
for each cell in rng
if cell.value<>"" then
cell.value=str_part & cell.value
end if
next
end sub
 
If a formula will do, try something like this (with the existing text in A1):

="Test to be inserted "&A1

You can copy te formula down. Then if you need the text to be just text, you can copy and paste special, values.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Behavior of text in cells..... 1
How do you insert a phrase at the start of all cells in a column? 3
Insert Object Problem 1
trying to insert a 0 in front of zipcode 2
insert document properties text in a cell 2
Adding Dashes in front of text using text formating 1
can a symbol be inserted in front of existing data 3
Text - Remove text Item No.99 (First 2 Chars) and move to end 5

Back
Top