Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Pankaj Sharma
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

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Swapnil Palande
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

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Nur Hossain
* - -- *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

$$Excel-Macros$$ Text separated with formula

2015-05-12 Thread Nur Hossain
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

Re: $$Excel-Macros$$ Text separated with formula

2015-05-12 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Text separated with formula

2015-05-12 Thread Nur Hossain
@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