i need to cut the first 14 characters from a text string - for instance I
need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense". I
can't use the function "Right" as the right part of the cell is a variable
number of characters.

Thanks for your help!!!

If its always 14 characters, with "E-100-250-4332 Rental Expense" in A1,
=LEFT(A1,14)
Regards,
Alan.
"LAndersen" wrote in message
...
i need to cut the first 14 characters from a text string - for instance I
need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense". I
can't use the function "Right" as the right part of the cell is a variable
number of characters.

Thanks for your help!!!

How about the LEFT?

=LEFT(A1,14)

HTH,
Elkar


"LAndersen" wrote:

i need to cut the first 14 characters from a text string - for instance I
need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense". I
can't use the function "Right" as the right part of the cell is a variable
number of characters.

Thanks for your help!!!

No - using "left" will not work. I could cut the first 14 characters in the
cell and be left with the variable number of characters on the right, but I
can't remember what the function is to do this. Basically, I don't want
anything copied from the cell - I want the first 14 characters actually cut
out.

Thanks for your help!!

"Elkar" wrote:

How about the LEFT?

=LEFT(A1,14)

HTH,
Elkar


"LAndersen" wrote:

i need to cut the first 14 characters from a text string - for instance I
need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense". I
can't use the function "Right" as the right part of the cell is a variable
number of characters.

Thanks for your help!!!

Take a look at "Text to Columns" in the Data menu. It sounds like this may
accomplish what you're looking for.



"LAndersen" wrote:

No - using "left" will not work. I could cut the first 14 characters in the
cell and be left with the variable number of characters on the right, but I
can't remember what the function is to do this. Basically, I don't want
anything copied from the cell - I want the first 14 characters actually cut
out.

Thanks for your help!!

"Elkar" wrote:

How about the LEFT?

=LEFT(A1,14)

HTH,
Elkar


"LAndersen" wrote:

i need to cut the first 14 characters from a text string - for instance I
need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense". I
can't use the function "Right" as the right part of the cell is a variable
number of characters.

Thanks for your help!!!

You can try this:

=RIGHT(A1,LEN(A1)-14)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LAndersen" wrote in message
...
No - using "left" will not work. I could cut the first 14 characters in
the
cell and be left with the variable number of characters on the right, but
I
can't remember what the function is to do this. Basically, I don't want
anything copied from the cell - I want the first 14 characters actually
cut
out.

Thanks for your help!!

"Elkar" wrote:

How about the LEFT?

=LEFT(A1,14)

HTH,
Elkar


"LAndersen" wrote:

i need to cut the first 14 characters from a text string - for instance
I
need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense".
I
can't use the function "Right" as the right part of the cell is a
variable
number of characters.

Thanks for your help!!!