software

I am trying to extract characters to the left of position 3 in a variable
length character string.

Examples: 12548698; 124586; 111478566

In the above I want to get the following 12548; 124; 111478

I have successfully extracted the last 3 characters using the RIGHT function
now I need the number left after the extraction

Have tried several formulas but no luck

Thanks for any help

Emile
Try something like this:

For a string in A1

B1: =LEFT(A1,LEN(A1)-3)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Emilequot; wrote:

gt; I am trying to extract characters to the left of position 3 in a variable
gt; length character string.
gt;
gt; Examples: 12548698; 124586; 111478566
gt;
gt; In the above I want to get the following 12548; 124; 111478
gt;
gt; I have successfully extracted the last 3 characters using the RIGHT function
gt; now I need the number left after the extraction
gt;
gt; Have tried several formulas but no luck
gt;
gt; Thanks for any help
gt;
gt; Emile
gt;
gt;
gt;

Try...

=LEFT(A1,LEN(A1)-3)

Hope this helps!

In article gt;,
quot;Emilequot; gt; wrote:

gt; I am trying to extract characters to the left of position 3 in a variable
gt; length character string.
gt;
gt; Examples: 12548698; 124586; 111478566
gt;
gt; In the above I want to get the following 12548; 124; 111478
gt;
gt; I have successfully extracted the last 3 characters using the RIGHT function
gt; now I need the number left after the extraction
gt;
gt; Have tried several formulas but no luck
gt;
gt; Thanks for any help
gt;
gt; Emile

Thank you both

I knew the answer was simple.

As always, I really appreciate the support from fellow users.

Thanks again

Emile