Help needed with text to columns.

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.
 
C

Chris Mitchell

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...
 
S

ShaneDevenshire

Hi,

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

Rakesh Khowal

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