Help needed with text to columns.

[Chris Mitchell]

I have a list where the contents are of variable length, but fit a pattern,
e.g. "variable length string MON DD, variable length string", where MON DD
= Month and Day and MON is variable, i.e. Jan, Feb etc.

I want to split the text to columns at the Month, so need to be able to
split on 6 characters (including the space) before the comma.

How can I do this?

Or is there a different/better way to do this?

TIA.

Chris.

 

[Niek Otten]

=LEFT(A1,FIND(",",A1)-6)
and
=RIGHT(A1,LEN(A1)-FIND(",",A1))

 

[Chris Mitchell]

Thanks Niek, worked a treat.

=LEFT(A1,FIND(",",A1)-6)
and
=RIGHT(A1,LEN(A1)-FIND(",",A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[ShaneDevenshire]

Hi,

Use the Data, Text to Columns command, Delimited, with the delimiter between
the month and day, probably Space.

 

[Rakesh Khowal]

Hi,

Use the Data, Text to Columns command, Delimited, with the delimiter between
the month and day, probably Space.

Use search function to count length where the pattern start from. then
substring to separate out the the patter from the string. If you
forward me the excel sheet. I can do this.

Rakesh Khowal.