formula problem

[AB]

Hi List,
I have a column that has a number in (it is the age) and I want to add the
letter "y". Have tried a column of y's then concatenate, but then when I
delete the surplus column, the y disappears. Any solutions?
Thanks
Althea

 

[Norman Harker]

Hi AB!

So near!

Insert that column of ys again and use the concatenation. Then select
the concatenation column and
Copy
Edit > Paste Special > Values
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[AB]

--
Thankyou, so much, and especially for the prompt reply.
Regards
Althea

 

[Ron Rosenfeld]

Hi List,
I have a column that has a number in (it is the age) and I want to add the
letter "y". Have tried a column of y's then concatenate, but then when I
delete the surplus column, the y disappears. Any solutions?
Thanks
Althea

One other solution, if you want to keep your result as a number (perhaps to use
it in other formulas), would be to custom format the cell:

Format/Cells/Number/Custom/Type: 0\y or 0 \y



--ron

 

[Norman Harker]

Hi AB!

Always pleased to Help.

Reply is pretty fast but not exceptional these days.

Happy New Year

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.