Sure.
1. When you import the text file, choose *Delimited* and put " (inverted
commas) in the *Other* field. This will take address in a separate column.
Adjust the values of addresses by removing first blank cell.
2. After you have imported, insert a column after the name and choose *Text
to Colu
Perfect Abhishek, Thanx a lot, may I ask you, which formulae or
function is been used to do this ? Please...
Regards
Sandeep
On Wed, Feb 20, 2013 at 2:02 PM, Abhishek Jain wrote:
> Does this work for you?
>
>
> On Wed, Feb 20, 2013 at 1:46 PM, Sandeep wrote:
>>
>> Thanx Abhishek,
>>
>> Still w
Does this work for you?
On Wed, Feb 20, 2013 at 1:46 PM, Sandeep wrote:
> Thanx Abhishek,
>
> Still waiting for my query to be resolved, meanwhile I'm sharing the
> .txt file for your better insight.
>
>
> Regards
>
> Sandeep
>
> On Wed, Feb 20, 2013 at 12:34 PM, Abhishek Jain
> wrote:
> > Hi
Thanx Abhishek,
Still waiting for my query to be resolved, meanwhile I'm sharing the
.txt file for your better insight.
Regards
Sandeep
On Wed, Feb 20, 2013 at 12:34 PM, Abhishek Jain wrote:
> Hi Sandeep,
>
> Welcome to the group. I hope that the experts here would help resolve your
> query.
Hi Sandeep,
Welcome to the group. I hope that the experts here would help resolve your
query.
Meanwhile, could you also share with us the text file (in its original
format) from which you have imported this data. I believe it would help in
getting a better insight.
Thanks,
Abhishek
On Wed, Fe
Dear Experts,
This is my first interaction with this group though I have been a
member of this group for a long. Let me introduce my self as Sandeep,
works for the Hospital in Accounts department. Most of my work is
related with excel and I do have a sound knowledge of excel but not to
the expert
