Re: $$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-31 Thread Vaibhav Joshi
character which you see may not be the same which you type, press F2 & copy characters & then you can do Find replace copied character with unique character like underscore or so & after that goto data text to column.. On Tue, Mar 31, 2015 at 12:22 AM, Bill Q wrote: > Thanks, but I must be doing

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-30 Thread Mandeep Baluja
dont type -- manually just copy it and replace otherwise replace will not work. On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote: > > Thanks, but I must be doing something wrong - becuase it isn;t working for > me. > > On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote: >> >>

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-30 Thread Mandeep Baluja
Copy your double code in replace box don't type it it will get easily replaced. On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote: > > Thanks, but I must be doing something wrong - becuase it isn;t working for > me. > > On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote: >> >>

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-30 Thread Bill Q
Thanks, but I must be doing something wrong - becuase it isn;t working for me. On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote: > > Attached is a very small sample of a much larger data set. I need to > separate the data - in this case in 3 different and separate columns. For > whatever

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-29 Thread Mandeep Baluja
Replace double -- with single - and then text to columns. On Monday, March 30, 2015 at 3:07:58 AM UTC+5:30, Bill Q wrote: > > Attached is a very small sample of a much larger data set. I need to > separate the data - in this case in 3 different and separate columns. For > whatever reason there i