split string to another cell when find .dot

[farrukh]

HI All ,

I have some Comments (string) in the Column. Suppose

String

Flow rates given above are field estimates. Actual billing figures will be communicated at the end of the month.field is empty. Another line.

I need that every .dot (when the string ends) the other string split to other cell and so on?

Any help would be appreciated...

Thanks
frexxz

[Steffen Thomsen]

Please Login or Register  to view this content.

[farrukh]

HI Thomson,

I am getting an error compile error Sub or function not defined.

Thanks
Frexxz

[Steffen Thomsen]

Sorry, miss-spelled/typed a character

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[farrukh]

HI Thomson and Snb,

Please Login or Register  to view this content.

Works perfectly thanks you so much Thomson & Snb your code works fine

Regards,
Frexxz