I need a formula to cut the first X characters from the left and the last Y characters from the right of a text string. Anyone know how to do this? Thanks in advance.
How do you want the result to look? Will it be two text strings or do you want to concatenate them into one string? Or are these actually text representations of numbers you will want to be formatted as numbers?
On 2002-03-12 12:42, Anonymous wrote:
I need a formula to cut the first X characters from the left and the last Y characters from the right of a text string. Anyone know how to do this? Thanks in advance.
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.