Symbol in front of Text - Reg

  • Thread starter Thread starter fitzol
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

check Text 2
Diameter and Dgree symbols 3
Greek Letters or Symbols in Excel 6
Meaning of symbols used in access 3
Automatic Symbol Insertion In Cell 1
Euro symbol in queries 11
# symbol appearing instead of typed text in a cell 1
remove the "+" symbol in front of phone numbers 4

Back
Top