| 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? |
| 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 | |||
![Paul B[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
