I have this
CV088B40
CV088B41
CV088B42
CV088B43
I want this
CV088B
CV088B
CV088B
CV088B
Formula on b1 and down , data on a1 and down
I have this
CV088B40
CV088B41
CV088B42
CV088B43
I want this
CV088B
CV088B
CV088B
CV088B
Formula on b1 and down , data on a1 and down
=left(a1,len(a1)-2)
Paste this formula in Cell B1
=LEFT(A1,LEN(A1)-2)
Or Data - Text to columns - Fixed with - Enter separator before the last two digits - Next - Select "do not import" for the second column - Finish
Thank you all ,
I am sorted
I will pick the formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks