ExcelBanter - Parse this string

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Parse this string (https://www.excelbanter.com/excel-discussion-misc-queries/131375-parse-string.html)

David

Parse this string

XL2000
In A2, I have the following string:
Date: February, 2007
For reason, I have to leave the entire string in a single cell.

How can I parse out the month and year without the comma?

--
David

JE McGimpsey

Parse this string

One way:

=TRIM(SUBSTITUTE(MID(A2, FIND(":",A2)+1, 255), ",", ""))

In article ,
David wrote:

XL2000
In A2, I have the following string:
Date: February, 2007
For reason, I have to leave the entire string in a single cell.

How can I parse out the month and year without the comma?

David

Parse this string

JE McGimpsey wrote

One way:

=TRIM(SUBSTITUTE(MID(A2, FIND(":",A2)+1, 255), ",", ""))

In article ,
David wrote:

XL2000
In A2, I have the following string:
Date: February, 2007
For reason, I have to leave the entire string in a single cell.

How can I parse out the month and year without the comma?

Brilliant!! Thanks

--
David

All times are GMT +1. The time now is 11:38 AM.