Help Creating Cell Formula Created From Data In Another Cell

[gaspower]

Hello,

I have text data in column A cells. I am needing help with a formula in column B cell to output the below.

I am using four columns to get to the end result, and would prefer to have data in Column A and result be in Column B.

This is what I have now,

Cell A1 Contains Text: Fast answers need clear examples

Cell B1 Contains formula: =LOWER(A1)

Cell C1 Contains formula: =SUBSTITUTE(B1," ","-")

Cell D1 Contains formula: =C1&".html"

Which then gives me the output in D1 of fast-answers-need-clear-examples.html

Thank you,
JR

[maniacb]

Instead of VBA, you can combine your formulas into B1 as follows:

=SUBSTITUTE(LOWER(A1)," ","-")&".html"

[gaspower]

Hello,
Perfect. Thank you. Actually that was what I was trying to ask, but did not explain it well. I appreciate the help.

JR