Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

prefix/suffix text

  Asked By: Marjorie    Date: Aug 19    Category: MS Office    Views: 986
  

I have multiple lines of html code which I want to prefix & suffix to a
cell value. I know how to add few words but not multiple lines.
Any ideas?

my code:
Public Sub AddText()

Range("G2").Select
Do While ActiveCell.Value <> ""

ActiveCell.Value= "TEXT GOES HERE" & ActiveCell.Value & "TEXT GOES HERE"
ActiveCell.Offset(1, 0).Select

Loop

End Sub

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Camille Garrett     Answered On: Aug 19

1) Please do not use "URGENT" in the subject. It is not urgent to us.

2) Please be much more specific. I have no idea what your problem is.
Provide an example of what you're trying to do and what the result is
expected to be.

 
Answer #2    Answered By: Olivia Campbell     Answered On: Aug 19

Say cell value=  my world

I wanna append few lines  to this text.

say I wanna make the cell value =
one
my world
two

 
Answer #3    Answered By: Hariz Burki     Answered On: Aug 19

This example does not fit "few lines". It looks like you simply want to put
a liner feed before and after your cell's information. There are two easy
ways:

- If you are appending with quoted strings, put Alt-Enter inside the strings
at the places you want the line feeds.

- Otherwise, concatenate CHAR(10) into your result at the places you want
the line feeds.

You will need to turn wrapping on for the cell.

 
Answer #4    Answered By: Bien Nguyen     Answered On: Aug 19

Sorry i don't get it.
I have long html  code liines to be prefixed & suffixed to a cell
value.
The html code  also has double quote charcater.

 
Didn't find what you were looking for? Find more on prefix/suffix text Or get search suggestion and latest updates.




Tagged: