Simple Formula - I Think!!!

  • Thread starter Thread starter Mike Kiekover
  • Start date Start date
M

Mike Kiekover

How can I get text to follow a formula in a cell. What I want to do is
simple - If I type 100 in cell A1 I want cell B1 to show 100a

=(A1) gets me the value from cell A1, but how do I get the "a" to follow???

Mike K
 
Are you just looking to simply concatenate the value in one cell with text?
If so, try:

=concatenate(A1, "a")

Ken
 
That works to!!!

Thanks Kenneth


Kenneth E. Coakley said:
Are you just looking to simply concatenate the value in one cell with text?
If so, try:

=concatenate(A1, "a")

Ken
Click to expand...
 
Is it not possible to create a format to do this instead?
Select the cell, press CTRL-1, select "Number" and "Custom" and type "0a" in
the "Type" field.

Regards Tobbe G
 
Mike,

If you put in cell B1 the formula =A1&"a" you get 100a in cell B1.
This is actually a different value in B1 then in A1.

The solution of Tobias doesn't change the value (it still is 100), but only
changes the way it is showed.
It is up to you what you want.


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top