Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine text and number with preceeding zeroes
Mac, here is one way
=A1&" 000"&B1&"; "&C1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "mac52187" wrote in message ... I wish to combine text "ABCD" from first cell with "123" from other cell and "XYZ" from third cell to display as "ABCD 000123; XYZ" Can somebody help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine text and number with preceeding zeroes
=A1&" "&TEXT(B1,"0000")&" "&C1
Vaya con Dios, Chuck, CABGx3 "mac52187" wrote in message ... Thanks for the reply Paul. But the problem is I used CONCATENATE(A1," ",B1,"; ",C1) Where B1 is formatted as"000000" the problem is that the result is ABCD 123; XYZ Where as is need it to be ABCD 000123; XYZ.( here 123 can be any 6 digit number with preceeding zeroes) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine text and number with preceeding zeroes
Sorry mac.............
Some musta got lost in the translation............ =A1&" "&TEXT(B1,"000000")&"; "&C1 Vaya con Dios, Chuck, CABGx3 "CLR" wrote in message ... =A1&" "&TEXT(B1,"0000")&" "&C1 Vaya con Dios, Chuck, CABGx3 "mac52187" wrote in message ... Thanks for the reply Paul. But the problem is I used CONCATENATE(A1," ",B1,"; ",C1) Where B1 is formatted as"000000" the problem is that the result is ABCD 123; XYZ Where as is need it to be ABCD 000123; XYZ.( here 123 can be any 6 digit number with preceeding zeroes) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number to text without losing zeroes | Excel Discussion (Misc queries) | |||
first number after zeroes in sequence | Excel Worksheet Functions | |||
EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER | Excel Discussion (Misc queries) | |||
Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions |