Dear Tom Jeffries,
I really felt happy to see the macro code you have build up for solving the
problem of separating Bold Strings for your reference is BoldParse Macro.
Tom just i need one help from you is that can you tell if a person doesnt
knows about the Macros for building up the code and ge
I noticed you were looking for a function rather than a subroutine. The
attached file contains a function (BoldParse) that parses your strings. Use
whichever meets your needs.
Tom
On Wed, Nov 12, 2008 at 2:27 AM, atta khan <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> What i want to do is to sepa
The attached workbook contains a macro (ParseBold) that does what you
describe. If you have any questions let me know.
On Wed, Nov 12, 2008 at 2:27 AM, atta khan <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> What i want to do is to separate BOLD text from a string by a formula or VB
> function. As
Hello All,
What i want to do is to separate BOLD text from a string by a formula or VB
function. As I have a lot of data I can't do it manually.
For example
*East Doncaster* Victoria, Australia.
I want "East Doncaster" in one column and "Victoria, Australia" in other.
Please provide help
than
If there is space between tel no & e-mail id,:
1. Go to data menu
2. Select text to colmuns
3. Select delimited
4. Click on next and select space
5. Click next and then finish
Ur data will be seperated.
On Nov 8, 10:13 am, [EMAIL PROTECTED] wrote:
> In excel,i have a column having the phonenumbe
Hi there,
Hope you doing great!
This is in reference to your problem. Please follow the below listed steps.
Select the Entire Column with the Data viz. A and then,
Go To Data
Click Text To Column
Select Fixed Width then Click Next
You'd see partial Data @ Data Preview
Just Click over the scale a
