Extract data into separate cells

[buteaur]

Hello.

I have data in a cell that I need to extract into seperate cells. Here's the example:

14 = Street RCA Combo #203: Task BG0178
15 = Street RCA Combo #204: Task BG0018
16 = Street RCA Combo #205: Task BG0020
17 = Street RCA Combo #206: Task BG0022
18 = Street RCA Combo #207: Task BG0348

The issue I'm having is getting these to be extracted properly into their own cells.

I need the first number to get into it's own cell, I need the number after "combo" to be in it's own cell and then I need the last number (BGxxxx" to be in it's own cell.

I can't figure it out.... Any help is appreciated.

 

[buteaur]

Hello. Thank you for the reply. Agreed, I'm not being very clear.

My data starts at A1. The results of the forumula you wrote are in B1, C1, D1 with the corresponding data from A1 in B2, C2, D2, through BCD5

The next cell of data is now in A7. I'm trying to find a way to make the formula repeat every 7 rows.

As of now, it will not work because the formula defaults to A1. If i have to manually change all of these as I go, I can. I was just hoping their was an easy way to copy and drag through the entire workbook.

Thank you!