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

S

shrinivasmj

Board Regular
Joined
Aug 29, 2012
Messages
140
i have a data in a1 cell

LINDA ANDREWS GriggZody WestColumBia


b1 -should come like below { put after cpas latter

LINDA ANDREWS { Grigg Zody West Colum Bia


<tbody>
</tbody>
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
Could you give another 5-10 examples and their expected results so that we can see how varied the data is?
 
Upvote 0
LINDA ANDREWS GriggZody WestColumBia
WILLIAM-MEYER Diborah Proto Cudahy
USAMINDORI@AOL.COM Grigory ThompsonCayce
GARDYL.SWINDLE DianntomczakOnalaska
ALBIRT PITRIQUIN DonBinnitt
LINDA ANDREWS GriggZody WestColumBia
WILLIAM-MEYER Diborah Proto Cudahy
USAMINDORI@AOL.COM Grigory ThompsonCayce
GARDYL.SWINDLE DianntomczakOnalaska
ALBIRT PITRIQUIN DonBinnitt

<colgroup><col></colgroup><tbody>
</tbody>

<colgroup><col></colgroup><tbody>
</tbody>
 
Upvote 0
LINDA ANDREWS GriggZody WestColumBia
WILLIAM-MEYER Diborah Proto Cudahy
USAMINDORI@AOL.COM Grigory ThompsonCayce
GARDYL.SWINDLE DianntomczakOnalaska
ALBIRT PITRIQUIN DonBinnitt

<tbody>
</tbody>
 
Upvote 0
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
AB
1LINDA ANDREWS GriggZody WestColumBiaLINDA ANDREWS { GriggZody WestColumBia
2WILLIAM-MEYER Diborah Proto CudahyWILLIAM-MEYER { Diborah Proto Cudahy
3USAMINDORI@AOL.COM Grigory ThompsonCayceUSAMINDORI@AOL.COM { Grigory ThompsonCayce
4GARDYL.SWINDLE DianntomczakOnalaskaGARDYL.SWINDLE { DianntomczakOnalaska
5ALBIRT PITRIQUIN DonBinnittALBIRT PITRIQUIN { DonBinnitt
6LINDA ANDREWS GriggZody WestColumBiaLINDA ANDREWS { GriggZody WestColumBia
7WILLIAM-MEYER Diborah Proto CudahyWILLIAM-MEYER { Diborah Proto Cudahy
8USAMINDORI@AOL.COM Grigory ThompsonCayceUSAMINDORI@AOL.COM { Grigory ThompsonCayce
9GARDYL.SWINDLE DianntomczakOnalaskaGARDYL.SWINDLE { DianntomczakOnalaska
10ALBIRT PITRIQUIN DonBinnittALBIRT PITRIQUIN { DonBinnitt
Insert Bracket
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,217,376
Messages
6,136,195
Members
449,998
Latest member
jpaul123

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top