Excel – Splitting a sentence into 2 columns after a word or text

…or certain text.

For example –

From GTMetrix, I want to split the sentences into the image URL and the note about how to reduce the data size of the image

https://www.businessdaduk.com/wp-content/uploads/house-logo-white.png is resized in HTML or CSS from 5151×2687 to 5151×110. Serving a scaled image could save 69.1KiB (95% reduction).”

I want to separate / split into:

"https://www.businessdaduk.com/wp-content/uploads/house-logo-white.png"
"is resized in HTML or CSS from 5151x2687 to 5151x110. Serving a scaled image could save 69.1KiB (95% reduction)."

To do this put the full sentence into cell A3

Then in an adjacent cell put:

=FIND(".png",A3)+4

and in the cell next to that one put:

=LEFT(A3,T3-1)

In the example, the first formula is put in cell T3.

Advertisements