- Original Message -
From: "Sandeep"
To:
Sent: Sunday, August 16, 2009 9:55 AM
Subject: Re: $$Excel-Macros$$ Re: replace when large data in cell
> Hi,
>
>I have to replace ! in the workbook, you can use what ever you want in
> place of !. But the find an
you can use the number of occurance of the old text like 1 or 2 etc to
replace only first or second occurance of the old text.
Thanks & Regards
Sandeep
- Original Message -
From: "fongie"
To: "MS EXCEL AND VBA MACROS"
Sent: Friday, August 14, 2009 7:16
e your file)
> Is you did it by find and replace?
>
> Is it possible in Office 2003?
>
>
> - Original Message -
> *From:* Aindril De
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, June 24, 2009 9:52 PM
> *Subject:* $$Excel-Macros$$ Re: replace w
Hi Sandeep
Did you manage to resolve your problem?
There was the suggestion to take the data into a notepad file. I
tried that but could not get it to work myself.
Did something similar to take the data into MS Word instead then back
to Excel which placed each line of the cell into individual
cel-macros@googlegroups.com
Sent: Wednesday, June 24, 2009 9:52 PM
Subject: $$Excel-Macros$$ Re: replace when large data in cell
Hi Sandeep I hope you have recd the attached file now...
The process explained to you... was used to derive the result you required...
By the way do you use MS O
the this process is not
> working.
>
> - Original Message -
> *From:* Aindril De
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, June 24, 2009 7:08 PM
> *Subject:* $$Excel-Macros$$ Re: replace when large data in cell
>
> Dear Sandeep,
>
> Pleas
Thanks Aindril, but there is no attached file and the this process is not
working.
- Original Message -
From: Aindril De
To: excel-macros@googlegroups.com
Sent: Wednesday, June 24, 2009 7:08 PM
Subject: $$Excel-Macros$$ Re: replace when large data in cell
Dear Sandeep
: Wednesday, June 24, 2009 6:02 PM
Subject: $$Excel-Macros$$ Re: replace when large data in cell
Hi Sandeep,
One quick way could be, copy the data from cell and paste that into Notepad.
Now copy again data from Notepad and paste in another Excel tab, by clicking on
a single cell. This will
Sorry forgot to upload the file...
Regards,
Andy
On Wed, Jun 24, 2009 at 8:38 PM, Aindril De wrote:
> Dear Sandeep,
>
> Please find attached the updated file. It shd not be an issue.
> Just say select all... then Ctrl + H to open the Find Replace box...
> In Find type "
> In Replace type \"
>
>
Dear Sandeep,
Please find attached the updated file. It shd not be an issue.
Just say select all... then Ctrl + H to open the Find Replace box...
In Find type "
In Replace type \"
Then press replace all.
Regards,
Andy
On Wed, Jun 24, 2009 at 6:46 PM, Sandeep wrote:
> Hi Everybody,
>
> Please
Hi Sandeep,
One quick way could be, copy the data from cell and paste that into
Notepad. Now copy again data from Notepad and paste in another Excel tab,
by clicking on a single cell. This will distribute the data in different
cells / rows.
After doing this, you can go ahead and use "Find and Rep
11 matches
Mail list logo
