Re: Extracting text from a formula?
From: Jason Morin (jason.morin_at_us.exel.com)
Date: 02/20/04
- Next message: Frank Kabel: "Re: HELP!need to determine price based on time to complete using Min. Hour. And days"
- Previous message: Ken: "Re: Average only cells containing Numbers"
- In reply to: Richard m: "Extracting text from a formula?"
- Next in thread: Frank Kabel: "Re: Extracting text from a formula?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Feb 2004 10:27:22 -0800
One way:
=RIGHT(A1,LEN(A1)-2)
HTH
Jason
Atlanta, GA
>-----Original Message-----
>I have the following in a cell:
>
>=-This is test
>
>the above was imported from another program and I want to
extract the
>text part so I have *This is Text* as text.
>
>I have tried functions and code. The last code is and it
did not
>work.
>
>
>Code:
>--------------------
> ActiveCell = ActiveCell.FormulaR1C1 = ActiveCell.Offset
(0, 1)
>--------------------
>
>
>Can it be done and how.
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
- Next message: Frank Kabel: "Re: HELP!need to determine price based on time to complete using Min. Hour. And days"
- Previous message: Ken: "Re: Average only cells containing Numbers"
- In reply to: Richard m: "Extracting text from a formula?"
- Next in thread: Frank Kabel: "Re: Extracting text from a formula?"
- Messages sorted by: [ date ] [ thread ]
