var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Duplicate values to delete in seperate columns
I have a spreadsheet and I am try to remove part of the text that is similar in another column for example:
Column A Column B
654321 marbles and other stuff number 654321 to go
So I want to delete just the 654321 in column B is there a formula to do that?
Keep in mind that the numbers change for each row.
Thanks for your help!
This assumes that a space always follows the number.
C1: =IF(SEARCH(" ",B1,1)<>0,RIGHT(B1,LEN(B1) - SEARCH(" ",B1)),)
The copy over and paste values.