Is it possible to convert numeric to word in Excel ?

Question

Then what is the formula.
Secondly I want a formula to write e.g. "S Pathak,M,27" IN ONE COLUMN taking data from from four columns in anoither sheet; let us assume -A=Srinivas,B=Pathak,C=M,D=27

Answer 1

Value to Words
http://www.ozgrid.com/VBA/ValueToWords.htm

— — — — — — — — — — — — — — — — — — —

The function that merges the contents from cells to one cell is CONCATENATE.

=CONCATENATE(LEFT(A1,1)," ",B1,", ",C1,", ",D1)
-or you can just do it directly in a formula without a function
=LEFT(A1,1)&" "&B1&", "&C1&", "&D1

Answer 2

1. Do you mean that you want to convert number to word as in 1023 = One thousand and twenty three? If yes - there is no built-in function provided by excel to do that, however, I wrote a couple of macros a long time back to do this and I can share the code with you if you send me your workbook (I will put the code in so that when you enter a number and hit a button, the corresponding word gets printed).
you can email me at [e-mail]

2. Concatenating different cols is easy - you can use concatenate or simply Left(Ax,1) & " " & Bx & " " & Cx & " " Dx

PS:
Left(string, n) gets n left chars from the string
x denotes the row number eg A1 or A2 or A100, where you have the values

Answer 3

The simplest way I can think of (unless this is a commonly repeated task) would be to export the table as comma separated values, then import it as one column, not as comma separated.

Rawlyn.

Answer 4

Try the function =TEXT(value,format)

When linking text use the "&" sign.