| Home |
| Search |
| Today's Posts |
|
#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! |
| 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 | |||
![Dana DeLouis[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
