Thread
:
Concatenate
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Storm
external usenet poster
Posts: 58
Concatenate
Try this:
=TEXT(A1&B1&C1,"*,***,**0,000")
"Mac8128" wrote:
How can I concatenate three cells each with a number so that the concatenated
cell is a number, not text?
Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133
Reply With Quote
Storm
View Public Profile
Find all posts by Storm