Picking different text parts from a long text cell

[gustavocolli]

[FONT=Arial, Helvetica, sans-serif]I need some formulas to extract a certain part of the text from the main cell. I just can't think of a logical way to do that because using Left and Right will not work as the texts differ in lenght.[/FONT]

https://ibb.co/cv3NQxx

The columns B, C, D and E should give those small extracts from the main line. Anyone could please help me?!

Thanks in Advance!

 

[strooman]

I would proceed first with the Text to Columns Wizard (Data | Text to Columns) and pick the backslash (\) as delimeter. Then I repeat that process with the dash (-) as delimeter and then process further.

 

[Peter_SSs]

Could you give us some sample data in a form that we can copy? Having to type all that out is a bit onerous and would be prone to error.
My signature block below has some help in that regard.

Can you also clarify

- Why some of the cells in columns B:E are blank when there appears to be relevant data in column A?

- Whether the dates in the column A text are in yyyy-mm-dd format or yyyy-dd-mm format. Impossible to tell since none of the day or month values are greater than 12

 

[strooman]

Is this sample data correct, gustavocolli? Because I cannot see the whole line of column A. Like I said in Post #2 I would first go with a Text to Columns.

Excel 2016 Professional (Windows) 64 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td=bgcolor:#0070C0]Service line[/td][td=bgcolor:#0070C0]Product[/td][td=bgcolor:#0070C0]Billing Entity[/td][td=bgcolor:#0070C0]Project[/td][td=bgcolor:#0070C0]Date 1[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]\\optical\data\201906\longterm\Further Outlook Forecast Allseas - Able LT 2019-06-08.pdf longterm[/td][td]longterm[/td][td]Allseas[/td][td]Able LT[/td][td]

8-6-2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]\\optical\data\201906\longterm\Further Outlook Forecast Allseas - Able LT 2019-06-09.pdf[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]\\optical\data\201906\longterm\Further Outlook Forecast Boskalis - Bae Caerfyrddin LT 2019 longterm[/td][td]longterm[/td][td]Boskalis[/td][td]Bae Caerfyrddin LT[/td][td]

1-6-2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]\\optical\data\201906\longterm\Further Outlook Forecast Boskalis - Bae Caerfyrddin LT 2015 longterm[/td][td]longterm[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]\\optical\data\201906\squall\Squall Advisory Report BW Offshore - Squall Advisory for Sendje Berge - 2019-06-12 0243.pdf[/td][td]Squall[/td][td]BW Offshore[/td][td]Squal Advisory for Sendje Berge[/td][td]

12-6-2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]\\optical\data\201906\squall\Squall Advisory Report BW Offshore - Squall Advisory for Sendje Berge - 2019-06-12 1549.pdf[/td][td]Squall[/td][td][/td][td][/td][td]

12-6-2019​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]