Help needed with text to columns.

  • Thread starter Thread starter Chris Mitchell
  • Start date Start date
C

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.
 
Thanks Niek, worked a treat.

Niek Otten said:
=LEFT(A1,FIND(",",A1)-6)
and
=RIGHT(A1,LEN(A1)-FIND(",",A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
Click to expand...
 
Hi,

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

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

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.
 
Back
Top