Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to add extension to text ?
Dear Sir,
Lets consider the following worksheet: A B (Answer) 1 2115 2115.02.GT.0215 2 2145 2145.02.GT.0215 3 3245 3245.02.GT.0215 4 4128 4128.02.GT.0215 5 6627 6627.02.GT.0215 I have five account codes in column A and need to add extention .02.GT.0215 as illustrated in column B above. May I know what formula to be input at B1 and copy down to get the straight answer ? In another instance I have the folowing worksheet: A B C D F (Result) 1 2115 02 GT 0224 2115.02.GT.0224 2 2145 06 KU 0386 2145.06.KU.0386 3 3245 08 ST 0455 3245.08.ST.0455 I need to add the extentions for content in column B,C,D to the codes in column A. Is there any formula I can key in at column F to get the result I needed ? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to add extension to text ?
Here is one way to do it. For the first set of account codes, put this in
cell B1: =A1&".02.GT.0215" and drag it down column B. For the second set of account codes, put this in cell F1: =A1&"."&B1&"."&C1&"."&D1&"."&E1 and drag it down column F. HTH, James "Mr. Low" wrote in message ... Dear Sir, Lets consider the following worksheet: A B (Answer) 1 2115 2115.02.GT.0215 2 2145 2145.02.GT.0215 3 3245 3245.02.GT.0215 4 4128 4128.02.GT.0215 5 6627 6627.02.GT.0215 I have five account codes in column A and need to add extention .02.GT.0215 as illustrated in column B above. May I know what formula to be input at B1 and copy down to get the straight answer ? In another instance I have the folowing worksheet: A B C D F (Result) 1 2115 02 GT 0224 2115.02.GT.0224 2 2145 06 KU 0386 2145.06.KU.0386 3 3245 08 ST 0455 3245.08.ST.0455 I need to add the extentions for content in column B,C,D to the codes in column A. Is there any formula I can key in at column F to get the result I needed ? Thanks Low -- A36B58K641 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to add extension to text ?
Q1) =A1&".02.GT.2015"
Q2) =A1&"."&B1&"."&C1&"."&D1 but depending on how the 02, 06, 08 values were entered you may need to use =A1&"."&TEXT(B1,"00")&"."&C1&"."&D1 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mr. Low" wrote in message ... Dear Sir, Lets consider the following worksheet: A B (Answer) 1 2115 2115.02.GT.0215 2 2145 2145.02.GT.0215 3 3245 3245.02.GT.0215 4 4128 4128.02.GT.0215 5 6627 6627.02.GT.0215 I have five account codes in column A and need to add extention .02.GT.0215 as illustrated in column B above. May I know what formula to be input at B1 and copy down to get the straight answer ? In another instance I have the folowing worksheet: A B C D F (Result) 1 2115 02 GT 0224 2115.02.GT.0224 2 2145 06 KU 0386 2145.06.KU.0386 3 3245 08 ST 0455 3245.08.ST.0455 I need to add the extentions for content in column B,C,D to the codes in column A. Is there any formula I can key in at column F to get the result I needed ? Thanks Low -- A36B58K641 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to add extension to text ?
Hello James,
Great formula. It works very well. Many thanks Low -- A36B58K641 "Zone" wrote: Here is one way to do it. For the first set of account codes, put this in cell B1: =A1&".02.GT.0215" and drag it down column B. For the second set of account codes, put this in cell F1: =A1&"."&B1&"."&C1&"."&D1&"."&E1 and drag it down column F. HTH, James "Mr. Low" wrote in message ... Dear Sir, Lets consider the following worksheet: A B (Answer) 1 2115 2115.02.GT.0215 2 2145 2145.02.GT.0215 3 3245 3245.02.GT.0215 4 4128 4128.02.GT.0215 5 6627 6627.02.GT.0215 I have five account codes in column A and need to add extention .02.GT.0215 as illustrated in column B above. May I know what formula to be input at B1 and copy down to get the straight answer ? In another instance I have the folowing worksheet: A B C D F (Result) 1 2115 02 GT 0224 2115.02.GT.0224 2 2145 06 KU 0386 2145.06.KU.0386 3 3245 08 ST 0455 3245.08.ST.0455 I need to add the extentions for content in column B,C,D to the codes in column A. Is there any formula I can key in at column F to get the result I needed ? Thanks Low -- A36B58K641 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to add extension to text ?
Hello Bernard,
Great formula. It works very well. Many thanks. Low -- A36B58K641 "Bernard Liengme" wrote: Q1) =A1&".02.GT.2015" Q2) =A1&"."&B1&"."&C1&"."&D1 but depending on how the 02, 06, 08 values were entered you may need to use =A1&"."&TEXT(B1,"00")&"."&C1&"."&D1 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mr. Low" wrote in message ... Dear Sir, Lets consider the following worksheet: A B (Answer) 1 2115 2115.02.GT.0215 2 2145 2145.02.GT.0215 3 3245 3245.02.GT.0215 4 4128 4128.02.GT.0215 5 6627 6627.02.GT.0215 I have five account codes in column A and need to add extention .02.GT.0215 as illustrated in column B above. May I know what formula to be input at B1 and copy down to get the straight answer ? In another instance I have the folowing worksheet: A B C D F (Result) 1 2115 02 GT 0224 2115.02.GT.0224 2 2145 06 KU 0386 2145.06.KU.0386 3 3245 08 ST 0455 3245.08.ST.0455 I need to add the extentions for content in column B,C,D to the codes in column A. Is there any formula I can key in at column F to get the result I needed ? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : How to segregate text into columns ? | Excel Discussion (Misc queries) | |||
repeating text Excel 2002 | Excel Discussion (Misc queries) | |||
Transformation d'images avec une extension .jpg ou .jpeg en images avec extension .bmp ou .ico | Excel Discussion (Misc queries) | |||
Excel 2002 Will Not Print Text Boxes | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) |