Extract text to the right of a variable string?

Bryanf939

New Member
Joined
Dec 3, 2018
Messages
1
Hello everyone!

I use this forum extensively to get me through my Excel problems, but I haven't yet been able to find a solution for the following problem.

I have a bunch of text in column A1

FCL289AJDA
FCL3LASD
PEL383LLD

I am trying to extract the first part of the text and subsequent numbers only. I do not want the second part of the text to be outputted.

So for the above the output should be
FCL289
FCL3
PEL383

How can I do this in Excel? I tried using LEFT, RIGHT, FIND formulas, but I was never able to solve the issue if the length of the string differed.
 
Have you actually tested it ...???

Please do not be rude.
I would not have allowed myself to say that the formula fails in some cases if I did not test it before.
You doing that?
I use, in formulas ";" instead of "," (regional settings differently), and when replacing comma with a semicolon, the formula has erroneous results.
I hope you understand what I'm saying ...
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Please do not be rude.
I would not have allowed myself to say that the formula fails in some cases if I did not test it before.
You doing that?
I use, in formulas ";" instead of "," (regional settings differently), and when replacing comma with a semicolon, the formula has erroneous results.
I hope you understand what I'm saying ...

Feel free to post the results you are getting ...
 
Upvote 0
Normal formula...

=LEFT(A1,LOOKUP(1,-MID(A1,ROW($1:$99),1),ROW($1:$99)))
 
Last edited:
Upvote 0
Please do not be rude.
I would not have allowed myself to say that the formula fails in some cases if I did not test it before.
You doing that?
I use, in formulas ";" instead of "," (regional settings differently), and when replacing comma with a semicolon, the formula has erroneous results.
I hope you understand what I'm saying ...

Cant say as i saw the response as rude. Regardless of regional settings try it leaving the commas as commas in this part {1,2,3,4,5,6,7,8,9,0}
 
Upvote 0
Cant say as i saw the response as rude.

How is it possible to say that a formula does not work if you do not test it ???

Regardless of regional settings try it leaving the commas as commas in this part {1,2,3,4,5,6,7,8,9,0}

No. It's working if I change "," with ""

like this: {1\2\3\4\5\6\7\8\9\0}
 
Last edited:
Upvote 0
How is it possible to say that a formula does not work if you do not test it ???

It happens surprisingly often.

I suggest everyone calms down and moves on, please.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,986
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top