swaggerbox
08-11-2016, 03:26 AM
In each cell in column A, I need to remove a pagination reference that is patterned this way, [30-characterAddress]İMyCompanybbbYYY[43-character pagination details]
Both [30-characterAddress] and[43-character pagination details] could vary in each cell. Is there a way to do that using a function? See example below:
Example string: This is an example where I need to remove the string that starts 30 characters to the left of İMyCompanybbbYYY up to 43 characters to the right of string today.
Preferred Output: This is an example where I need to remove the string that starts today.
Both [30-characterAddress] and[43-character pagination details] could vary in each cell. Is there a way to do that using a function? See example below:
Example string: This is an example where I need to remove the string that starts 30 characters to the left of İMyCompanybbbYYY up to 43 characters to the right of string today.
Preferred Output: This is an example where I need to remove the string that starts today.