you can,
As long as ever you can.” - John Wesley
-
From: Nur Hossain nur2...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Wednesday, May 13, 2015 1:46 AM
Subject: Re: $$Excel-Macros$$ Text separated with formula
Hi Paul
use this
Selection.TextToColumns Destination:=Range(B1),
DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, Other:=True, _
otherchar:=_, fieldinfo:=Array(Array(1, 1), Array(2, 1), Array(3,
1)),TrailingMinusNumbers:=True
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
you can.” - John Wesley*
-
--
*From:* Nur Hossain nur2...@gmail.com
*To:* excel-macros excel-macros@googlegroups.com
*Sent:* Tuesday, May 12, 2015 12:17 PM
*Subject:* $$Excel-Macros$$ Text separated with formula
Dear all
*
-
--
*From:* Nur Hossain nur2...@gmail.com
*To:* excel-macros excel-macros@googlegroups.com
*Sent:* Wednesday, May 13, 2015 1:46 AM
*Subject:* Re: $$Excel-Macros$$ Text separated with formula
Hi Paul Schreiner, thanks for replay , I am using office 2007, yes I agree
Dear all , I am having a text strings which is separated by underscore ( _ )
.please remember numeric number may vary more or less
CELL A1= 10.20.193.49_255.255.255.240_1503
It need to be separated like below CELL wise form CELL A1
CELL B1= 10.20.193.49
CELL C1= 255.255.255.240
CELL D1= 1503
as ever you can.” - John Wesley
-
From: Nur Hossain nur2...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Tuesday, May 12, 2015 12:17 PM
Subject: $$Excel-Macros$$ Text separated with formula
Dear all , I am having a text strings
@googlegroups.com
*Sent:* Tuesday, May 12, 2015 12:17 PM
*Subject:* $$Excel-Macros$$ Text separated with formula
Dear all , I am having a text strings which is separated by underscore ( _
)
.please remember numeric number may vary more or less
CELL A1= 10.20.193.49_255.255.255.240_1503
It need