using symbols

  • Thread starter Thread starter demolay
  • Start date Start date
D

demolay

i want to add a symbol to my whole column. there are already some thing
written. for example
george
michael
raul
ronaldo
...

i want to add lets say a square symbol to every line:
(square) george
(square) michael
(square) raul
(square) ronaldo

how can this can be accomplished in a very simple way
 
There's a way to do it by using the Windows Character Map
utility, but the solution is font-dependent. I tested it
using Arial and Times New Roman.

Open the Character Map utility. Select character 0141, or
any other that displays as an open square. Copy it to the
character window. Return to the spreadsheet and edit each
instance as follows: Insert the cursor at the beginning
of the string, paste (this should paste the character you
copied in the Character Map window), and give yourself
another space or two if you want it to separate the square
from the rest of the text. Enter the result.

I tried editing using Alt+0141 directly, but it didn't
work - only the copy/paste worked.

If you're using a different font, you'll have to check if
there is a character in the map for that font that
displays as a square. If not, you may have to change the
font in the spreadsheet to one that does.

If you like this result, keep in mind you can use any of
the characters in the map the same way.

I expect another, more knowledgeable person could give you
a better answer, but if not, this works.

Hope it helps.
 
One way would be to add a "helper" column containing a formula, which adds
the square, and then remove the formula, leaving the revised text behind.
You could then copy this "helper" column over the original, OR, delete the
original.

For example, with text starting in A1, enter this in B1:

=CHAR(141)&A1

And drag down to copy as needed.

Now, while the column is *still* selected,
Right click in the selection and choose "Copy".
Right click again, and choose "PasteSpecial",
Click on "Values", then <OK>.

What you now have remaining in column B is strictly data, which you can copy
or move as you please.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




i want to add a symbol to my whole column. there are already some things
written. for example
george
michael
raul
ronaldo
...

i want to add lets say a square symbol to every line:
(square) george
(square) michael
(square) raul
(square) ronaldo

how can this can be accomplished in a very simple way?
 
Enter this in an adjacent column....

=CHAR(10) & cellref where cellref is top cell in the column with names.

Drag/copy down or double-click on the fill handle.

When happy, copy/paste special(in place)>values.

Delete original column.

Note: do not turn on "wrap text" or the squares and words will disappear.

You may want to use some other symbol in place of the square.

Insert>Symbol will get you a dialog box of symbols for various fonts.

Gord Dibben Excel MVP
 
Back
Top