Extracting text from text string

E

Emile

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
 
R

Ron Coderre

Try something like this:

For a string in A1

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

Does that help?

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

XL2002, WinXP-Pro
 
E

Emile

Thank you both

I knew the answer was simple.

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

Thanks again

Emile
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top