Hi,
Is it possible to have text/numbers and a formula in one cell?
Example:
1. In cell A1 with the # 500 and the formula (1+1)(2+2).
2. A comma between the # 500 and the formula.
3. Should appear like the following: 500,8
Thanks
Hi,
Is it possible to have text/numbers and a formula in one cell?
Example:
1. In cell A1 with the # 500 and the formula (1+1)(2+2).
2. A comma between the # 500 and the formula.
3. Should appear like the following: 500,8
Thanks
Last edited by Elegidos; 10-27-2009 at 07:36 PM.
Write this: ="500,"&(1+1)*(2+2)
Thanks for the response . Works great .Write this: ="500,"&(1+1)*(2+2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks