text editing function help

J

JenBasch

I am trying to figure out how write a macro for the following things t
happen:

_Column_1_ _-Column_2-_ _*Column_3*_
word1 -word2-
*word1word2*
word1 -word2-
*word1-word2*
word1 -word2 word3-
*word1word2word3*
word1 -word2 word3-
*word1-word2-word3*

Column 3 is what I am hoping for an output column using columns 1 & 2
I have figured out how to do the first 2 rows, I am having trouble th
3rd and 4th rows.

Please advise.
Thanks,
JenBasc
 
S

swatsp0p

Jen: do you want a Formula or a Macro?

Can we assume for word1 word2 word3 word1word2word3 you mean a formula
in column 4? (not col. 3, as that has your word3)

If you are using a Macro, what code are do you have for rows 1 and 2?

More info, please

Bruce
 
J

JenBasch

Bruce,

I tried to lay it out as best as I could in the original post, but
maybe it wasn't very understandable. word2 & word3 are both in column 3
(column 1 = plain text, -column 2 = italized text-, *column 3 = bold
text*) and that is where I'm running into my problem. I intially just
want a formula in column 3 to do this. Eventually I want a Macro to
look through a list of cells and have them all the different outputs
depending on what they find in column 1 and column 2. Hopefully this
makes things a little more clear.

Thanks,
Jen
 
S

swatsp0p

Is this what you are after?:

Code:
--------------------

|----A----|----B----|---C---|
1 dog....|house...|*doghouse*|
2 dog....|house...|*dog-house*|
3 red.....|dog house|*reddoghouse*|
4 red.....|dog house|*red-dog-house*|
 

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

Top