How do I delete a few words from a line of text?
 

I want to delete the first part of a heading but include the rest. Is there a
way to do this?

Example: March Budget and Marketing Results
Remove march budget.
--
Thanks,
Laura

How do I delete a few words from a line of text?
 

Edit Replace Find what: March Budget Replace with: leave it blank
Replace

"lauras03" wrote:

I want to delete the first part of a heading but include the rest. Is there a
way to do this?

Example: March Budget and Marketing Results
Remove march budget.
--
Thanks,
Laura

How do I delete a few words from a line of text?
 

MID(A1,FIND(" ",A1,FIND(" ",A1)+1),LEN(A1))

lauras03 wrote:
I want to delete the first part of a heading but include the rest. Is there a
way to do this?

Example: March Budget and Marketing Results
Remove march budget.

How do I delete a few words from a line of text?
 

I guess I didn't explain that enough. I have 2 worksheets. The "original" is
taking information from the "current" worksheet. I want to put on the
original a different title and want to input a cell from the current
worksheet less the first 2 words. Can I do that?
--
Thanks,
Laura


"Teethless mama" wrote:

Edit Replace Find what: March Budget Replace with: leave it blank
Replace

"lauras03" wrote:

I want to delete the first part of a heading but include the rest. Is there a
way to do this?

Example: March Budget and Marketing Results
Remove march budget.
--
Thanks,
Laura