need to give space for proper later and put diameter after caps

[shrinivasmj]

i have a data in a1 cell

[TABLE="width: 380"]
<tbody>[TR]
[TD="class: xl64, width: 380"]LINDA ANDREWS GriggZody WestColumBia


b1 -should come like below { put after cpas latter

LINDA ANDREWS { Grigg Zody West Colum Bia

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Could you give another 5-10 examples and their expected results so that we can see how varied the data is?

 

[shrinivasmj]

[TABLE="width: 427"]
<colgroup><col></colgroup><tbody>[TR]
[TD]LINDA ANDREWS GriggZody WestColumBia[/TD]
[/TR]
[TR]
[TD]WILLIAM-MEYER Diborah Proto Cudahy[/TD]
[/TR]
[TR]
[TD]USAMINDORI@AOL.COM Grigory ThompsonCayce[/TD]
[/TR]
[TR]
[TD]GARDYL.SWINDLE DianntomczakOnalaska[/TD]
[/TR]
[TR]
[TD]ALBIRT PITRIQUIN DonBinnitt[TABLE="width: 427"]
<colgroup><col></colgroup><tbody>[TR]
[TD]LINDA ANDREWS GriggZody WestColumBia[/TD]
[/TR]
[TR]
[TD]WILLIAM-MEYER Diborah Proto Cudahy[/TD]
[/TR]
[TR]
[TD]USAMINDORI@AOL.COM Grigory ThompsonCayce[/TD]
[/TR]
[TR]
[TD]GARDYL.SWINDLE DianntomczakOnalaska[/TD]
[/TR]
[TR]
[TD]ALBIRT PITRIQUIN DonBinnitt[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[shrinivasmj]

[TABLE="class: cms_table, width: 427"]
<tbody>[TR]
[TD]LINDA ANDREWS GriggZody WestColumBia[/TD]
[/TR]
[TR]
[TD]WILLIAM-MEYER Diborah Proto Cudahy[/TD]
[/TR]
[TR]
[TD]USAMINDORI@AOL.COM Grigory ThompsonCayce[/TD]
[/TR]
[TR]
[TD]GARDYL.SWINDLE DianntomczakOnalaska[/TD]
[/TR]
[TR]
[TD]ALBIRT PITRIQUIN DonBinnitt[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

In all of those examples, the upper case block finishes at either the first or second space.
If that is always the case try this, copied down.

Excel Workbook
	A	B
1	LINDA ANDREWS GriggZody WestColumBia	LINDA ANDREWS { GriggZody WestColumBia
2	WILLIAM-MEYER Diborah Proto Cudahy	WILLIAM-MEYER { Diborah Proto Cudahy
3	USAMINDORI@AOL.COM Grigory ThompsonCayce	USAMINDORI@AOL.COM { Grigory ThompsonCayce
4	GARDYL.SWINDLE DianntomczakOnalaska	GARDYL.SWINDLE { DianntomczakOnalaska
5	ALBIRT PITRIQUIN DonBinnitt	ALBIRT PITRIQUIN { DonBinnitt
6	LINDA ANDREWS GriggZody WestColumBia	LINDA ANDREWS { GriggZody WestColumBia
7	WILLIAM-MEYER Diborah Proto Cudahy	WILLIAM-MEYER { Diborah Proto Cudahy
8	USAMINDORI@AOL.COM Grigory ThompsonCayce	USAMINDORI@AOL.COM { Grigory ThompsonCayce
9	GARDYL.SWINDLE DianntomczakOnalaska	GARDYL.SWINDLE { DianntomczakOnalaska
10	ALBIRT PITRIQUIN DonBinnitt	ALBIRT PITRIQUIN { DonBinnitt
Insert Bracket