LEFT(A1,5) gives the same as LEFT(A2,5)

teachman

Active Member
Joined
Aug 31, 2011
Messages
321
Hello,

I'm having issues with the LEFT workbook function. See below for the example with the formula of =LEFT(A2,4).

A B
User Pedon ID4 left characters
S00CO6680033S00C
S00CO6680034S00C
S00KS055001-pitS00C

<colgroup><col><col></colgroup><tbody>
</tbody>

The same result appears everywhere the formula is used. If Column A has 30,000 entries and cell A15000 is S00CO6680033 using the same formula yields S00C. Any cell above B15000 the formula is copied to and any cell below B15001 the results are the same, S00C.

What is going on?

Thanks,
George Teachman
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Check that you haven't got calculation set to manual (it sounds like you have).
 
Upvote 0
Rory,

Yep, that was it. It never dawned on me because I have never had any reason to use anything but automatic calculation. Looks like Excel is trying to think again.

Thanks,

George Teachman
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

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