character editing

[niket8989]

In a particular column, i need to edit the first two and last character from the cells.

for example, in a cell, text is NM2300SL01J. I only want 2300SL01 and not the first two and last one character.

I used right function to edit but still its not getting desired results.


please help

[cbatrody]

Hi,

Welcome to the Forum. Please try the following formula in B1, considering that the text is in A1:

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

[niket8989]

thanks for the help.

but the problem also is that the data is unorganized. and randomly are there in the cells.so cant drag down the formula. any help on that front?

[cbatrody]

If you want the cell to be converted into numbers, please use the following formula-


=1*MID(A1,3,LEN(A1)-3)

[sktneer]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic