Question on Text to Column Function
- From: ylchuah <ylchuah.1tu9qo_1124165159.0029@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 15 Aug 2005 22:57:31 -0500
Hi,
I have some problem with the data after perform Text to Column
Function.
Eg: I have this no => 123456789
I want to add "-" in between become 1-234-567-89
So i Use Text To Column Function to separate 9 digit no to 4
column.
Then use this formula to combine:
[ =Column1&"-"&Column2&"-"&Column3&"-"&Column4 ]
Problem: when the no contain "0" in some location, like 102500301,
the no in column2 become 25, column3 become 3 and
column4 become 1.
after combine will become 1-25-3-1 (Actual needed is
1-025-003-01)
Can some one help to solve this problem (what code can be aded in VBA
to solve this)?
Regards
YL Chuah :eek:
--
ylchuah
------------------------------------------------------------------------
ylchuah's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25341
View this thread: http://www.excelforum.com/showthread.php?threadid=396025
.
- Follow-Ups:
- RE: Question on Text to Column Function
- From: Rowan
- RE: Question on Text to Column Function
- Prev by Date: RE: If-then statement that checks for existence of series 2
- Next by Date: Re: Curing #DIV/0!????
- Previous by thread: Re: How to realize "enable macro" by VBA when opening a file with macr
- Next by thread: RE: Question on Text to Column Function
- Index(es):
Relevant Pages
|
