I am working on a workbook. Below is the best I know how to put it.
Here I have a list of userid's.
theflyingswan
lisarenick105
lisarenick105
lisarenick105
Marcello_ponco
fsarlat
GuslandiAriel
JarredsmomKelly
IndiaFord10
daopen
Jahid89734684
Jahid89734684
MavisZaina
shankarbhil865
Jahid89734684
shankarbhil865
kathleencrockes
JohnUETrust
MotivationBook6
dannyt810
weightLossHub24
weightLossHub24
floriansteps
MotivationBook6
GlobalZasha
HaydonKathryn
VirAstuceRegim
Kada_soulayman
HisandHerTrove
I need the above divided into 240 ct charset. BUT when it splits is I need it to break a few charset early so I do not have to go back and clean it all up. Would be nice to use the symbol for a breakpoint to stop excel from breaking in the middle of a suerid. Below may be a better llok at what I want.
Take these users to break into 240 charset.
yogaowny
hambrains100
dannywo74964555
IMQFT
dannywo74964555
fatlossmusclex
babyboypics
diethealth_tips
ruccrocka
ActionComplete
vishne0
PattersonLela1
dherbs
NutriCargo
Hobble_Dragon
BoutiqueCooks
platz12345
surfkook006
Sarthakhans2
VandaAmit
marshawright
DevChau63740719
ElainePowellUK
shubham288025
Now lets say the 240 charset will be here.
marshaw
right
DevChau63740719
I would like to know how to stop it from splitting in the middle of a user id and have it insert two breaks after it and then pick up with the next full user id. Like below.
marshawright
DevChau63740719
Thanks
Bookmarks