Picking different text parts from a long text cell

gustavocolli

New Member
Joined
Jul 18, 2018
Messages
4
[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

Active Member
Joined
Oct 29, 2013
Messages
314
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,707
Office Version
365
Platform
Windows
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
 
Last edited:

strooman

Active Member
Joined
Oct 29, 2013
Messages
314
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
A
B
C
D
E
1
Service lineProductBilling EntityProjectDate 1
2
\\optical\data\201906\longterm\Further Outlook Forecast Allseas - Able LT 2019-06-08.pdf longtermlongtermAllseasAble LT
8-6-2019​
3
\\optical\data\201906\longterm\Further Outlook Forecast Allseas - Able LT 2019-06-09.pdf
4
\\optical\data\201906\longterm\Further Outlook Forecast Boskalis - Bae Caerfyrddin LT 2019 longtermlongtermBoskalisBae Caerfyrddin LT
1-6-2019​
5
\\optical\data\201906\longterm\Further Outlook Forecast Boskalis - Bae Caerfyrddin LT 2015 longtermlongterm
6
\\optical\data\201906\squall\Squall Advisory Report BW Offshore - Squall Advisory for Sendje Berge - 2019-06-12 0243.pdfSquallBW OffshoreSqual Advisory for Sendje Berge
12-6-2019​
7
\\optical\data\201906\squall\Squall Advisory Report BW Offshore - Squall Advisory for Sendje Berge - 2019-06-12 1549.pdfSquall
12-6-2019​
Sheet: Sheet1
 
Last edited:

Forum statistics

Threads
1,085,813
Messages
5,386,040
Members
401,980
Latest member
chaithanyakrishnagck

Some videos you may like

This Week's Hot Topics

Top