| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i add same prefix any text or number to the large datas?
For ex: In a column 1000 chech no is entered.
100100 100101 100102 I want to add prefix Ch. No. to all 1000 numbers like below Ch. No: 100100 Ch. No: 100101 How to add this to 1000 of ch. no. which is the shortest way to do this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add same prefix any text or number to the large datas?
A1 = 100100
In B1 enter the below formula = "Ch. No: " & A1 If this post helps click Yes --------------- Jacob Skaria "how do i add same prefix any text or num" wrote: For ex: In a column 1000 chech no is entered. 100100 100101 100102 I want to add prefix Ch. No. to all 1000 numbers like below Ch. No: 100100 Ch. No: 100101 How to add this to 1000 of ch. no. which is the shortest way to do this. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i add same prefix any text or number to the large datas?
Hightlight all of youe datas
Custom format, enter : "Ch. No: "0 Regards Bosco "how do i add same prefix any text or num" wrote: For ex: In a column 1000 chech no is entered. 100100 100101 100102 I want to add prefix Ch. No. to all 1000 numbers like below Ch. No: 100100 Ch. No: 100101 How to add this to 1000 of ch. no. which is the shortest way to do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To Refer particular Month in large datas | Excel Worksheet Functions | |||
| How to embed large number of variables in text inside a text box? | Excel Discussion (Misc queries) | |||
| How to create a prefix containing text and zero? | Excel Worksheet Functions | |||
| How to sort number with text in large function? | Excel Worksheet Functions | |||
| How do I enter a prefix number to a colum of numbers | Excel Worksheet Functions | |||
Linear Mode
