Symbol in front of Text - Reg

F

fitzol

Date : 10th April 2006

From
Fitzol

Dear Gentlemen,

I have the following requirement.

I have some data in cell A1. In B1 I want a particular character or a
Symbol or an alphabet to appear in front of what I enter.

Suppose I need letter G and in B1 if I type lkhhj It should appear G
lkhhj.
A space between is preferred.

Also in some cases I need to insert a symbol ( in most times "Ø" -
which comes by typing Alt+0216. The same is used for denoting
Diameter.)

Please give Suggestions.

Thanking you
G.Karthi
 
R

RagDyeR

You'll need to differentiate between numbers and text (they *don't*
cross-reference), and also *exactly* where to place the character:

Ø #;"G" @

OR

# Ø;@ "G"


--

Regards,

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

Format>Cell>Number
select Customized
enter: "Ø 0" (without quotes)

HTH
 
Top