Brother International WP7550JPLUS Owner's Manual - English - Page 112

RETURN., Center, Right, Search, Replace

Page 112 highlights

Left Center Right Search and Replace 'Ihis function aligns all alphanumeric data of a range to the left of the cells. 1 Move the cursor to a corner of the range of cells that you want to format and press MENU and select Edit; then select Left from the function menu. This message appears: Move cursor to end of block and press RETURN. 2. Move the cursor to the opposite corner of the range of cells that you want to format and press RETURN. The alphanumeric cells ofthe range are reformatted. This function centers all alphanumeric data in a range. Move the cursor to a corner of the range of cells that you want to format and press MENU and select Edit; then select Center from the function menu. Proceed as with the Left function to select the desired range of cells. This function aligns all alphanumeric data of a range to the right of the cells. Move the cursor to a corner of the range of cells that you want to format and press MENU and select Edit; then select Right from the function menu. Proceed as with the Left function to select the desired range of cells. These functions are described in Search on page 46 and Replace on page 47. Please refer to those sections for the basic operations. • The Search function can find both numeric and alphanumeric data, but only if the dCa appears in the input area. For example, you will be able to find aaa in a cell if it has been entered directly into the input area. If the same data is entered as @REPEAT("a",3), you will not be able to find it. • When replacing a string with another, this window will appear if the replacement has to take place in a protected cell; r Protected cell error! Press any key to continue. , .4 • If the replacement string is longer than 240 characters, this window will appear: Word(s) too long! OX to truncate data? Use cursor to select and press RETURN. DIM INO1 You can select YES, to omit the data in the replacement string to the right of the possible 240 characters and carry out replacement, or NO to cancel the function. Spreadsheet 104

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252

Left
'Ihis
function
aligns
all
alphanumeric
data
of
a
range
to
the
left
of
the
cells.
1
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
format
and
press
MENU
and
select
Edit;
then
select
Left
from
the
function
menu.
This
message
appears:
Move
cursor
to
end
of
block
and
press
RETURN.
2.
Move
the
cursor
to
the
opposite
corner
of
the
range
of
cells
that
you
want
to
format
and
press
RETURN.
The
alphanumeric
cells
of
the
range
are
reformatted.
Center
This
function
centers
all
alphanumeric
data
in
a
range.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
format
and
press
MENU
and
select
Edit;
then
select
Center
from
the
function
menu.
Proceed
as
with
the
Left
function
to
select
the
desired
range
of
cells.
Right
This
function
aligns
all
alphanumeric
data
of
a
range
to
the
right
of
the
cells.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
format
and
press
MENU
and
select
Edit;
then
select
Right
from
the
function
menu.
Proceed
as
with
the
Left
function
to
select
the
desired
range
of
cells.
Search
and
Replace
These
functions
are
described
in
Search
on
page
46
and
Replace
on
page
47.
Please
refer
to
those
sections
for
the
basic
operations.
The
Search
function
can
find
both
numeric
and
alphanumeric
data,
but
only
if
the
dCa
appears
in
the
input
area.
For
example,
you
will
be
able
to
find
aaa
in
a
cell
if
it
has
been
entered
directly
into
the
input
area.
If
the
same
data
is
entered
as
@REPEAT("a",3),
you
will
not
be
able
to
fi
nd
it.
When
replacing
a
string
with
another,
this
window
will
appear
if
the
replacement
has
to
take
place
in
a
protected
cell;
r
Protected
cell
error!
Press
any
key
to
continue.
,
.4
If
the
replacement
string
is
longer
than
240
characters,
this
window
will
appear:
Word(s)
too
long!
OX
to
truncate
data?
Use
cursor
to
select
and
press
RETURN.
DIM
INO1
You
can
select
YES,
to
omit
the
data
in
the
replacement
string
to
the
right
of
the
possible
240
characters
and
carry
out
replacement,
or
NO
to
cancel
the
function.
Spreadsheet
104