Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenating
How do I concatenate a fixed number (like "30") and the first two #'s of
another cell that also contains text? For example, joining 300 and another cell that has 2509Peters to form 3025 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenating
Assume data in A2 down
To return it as text, in B2, copied down: ="30"&LEFT(A2,2) To return it as a real number, in B2, copied down: =("30"&LEFT(A2,2))+0 -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "TED" wrote: How do I concatenate a fixed number (like "30") and the first two #'s of another cell that also contains text? For example, joining 300 and another cell that has 2509Peters to form 3025 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenating
Hi Ted
=30&Left(A1,2) will give 3025 as a text value =--(30&Left(A1,2)) will give 3025 as a numeric value -- Regards Roger Govier "TED" wrote in message ... How do I concatenate a fixed number (like "30") and the first two #'s of another cell that also contains text? For example, joining 300 and another cell that has 2509Peters to form 3025 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenating
If the number 30 is really "fixed" as you indicated (not sure about that
because of your use of 300 in your example), then make it 100 times larger (3000 instead of 30) and add it to the left 2 numbers... =3000+LEFT(A1,2) This returns a real number, not text. -- Rick (MVP - Excel) "TED" wrote in message ... How do I concatenate a fixed number (like "30") and the first two #'s of another cell that also contains text? For example, joining 300 and another cell that has 2509Peters to form 3025 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenating | Excel Discussion (Misc queries) | |||
Concatenating % | Excel Discussion (Misc queries) | |||
Concatenating Problem | Excel Discussion (Misc queries) | |||
Concatenating | New Users to Excel | |||
concatenating numbers | Excel Worksheet Functions |