| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String of numbers
Hi,
I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! -- Best regards Mia |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String of numbers
You can start with this
=replace(A1,"-","") & text(B1,"000000") -- HTH, Barb Reinhardt "Mia" wrote: Hi, I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! -- Best regards Mia |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String of numbers
Thank you,
I had god help from your suggestion but I solved it like this. =Left(B8;2)&Right(B8;4)&TEXT(P29;"000000") Tahnk yo agian! -- Best regards Mia "Barb Reinhardt" skrev: You can start with this =replace(A1,"-","") & text(B1,"000000") -- HTH, Barb Reinhardt "Mia" wrote: Hi, I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! -- Best regards Mia |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String of numbers
Just to point out, Barb used the wrong function in her response to you...
she should have used SUBSTITUTE instead of REPLACE. Try her formula this way... =SUBSTITUTE(A1,"-","") & TEXT(B1,"000000") -- Rick (MVP - Excel) "Mia" wrote in message ... Thank you, I had god help from your suggestion but I solved it like this. =Left(B8;2)&Right(B8;4)&TEXT(P29;"000000") Tahnk yo agian! -- Best regards Mia "Barb Reinhardt" skrev: You can start with this =replace(A1,"-","") & text(B1,"000000") -- HTH, Barb Reinhardt "Mia" wrote: Hi, I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! -- Best regards Mia |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String of numbers
Hello Mia,
=LEFT(A1,SEARCH("-",A1,1)-1)&RIGHT(A1,SEARCH("-",A1,1)+1)&"00"&B1 Jó szerencsét Sebő Gábor "Mia" wrote in message ... Hi, I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! -- Best regards Mia |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String of numbers
Thank you!
-- Best regards Mia "helene and gabor" skrev: Hello Mia, =LEFT(A1,SEARCH("-",A1,1)-1)&RIGHT(A1,SEARCH("-",A1,1)+1)&"00"&B1 Jó szerencsét Sebő Gábor "Mia" wrote in message ... Hi, I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! -- Best regards Mia |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String of numbers
The result I want in Cell C1: 450001005975
Other ways as stated.... =SUBSTITUTE(A1,"-","")*1E6 + B1 = = = = = = = HTH :) Dana DeLouis On 3/21/2010 8:43 AM, Mia wrote: Hi, I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column of Numbers in xls to String of Numbers in txt | Excel Discussion (Misc queries) | |||
| Converting String numbers into real numbers | Excel Programming | |||
| Converting String numbers into real numbers | Excel Programming | |||
| string of numbers | Excel Worksheet Functions | |||
| string of numbers | Excel Worksheet Functions | |||
Hybrid Mode
