Hi
I have a page of data in one particular cell (i imported an email into it). What i would like to do is remove many words between sentences so i am left with the data i require.
For example
Cell "A1" contains
Hello this is a test
Customer require
IF
Testing 123
etc,etc
I would like to only KEEP the words Testing 123.
In Word you can use a Range in the Find and Replace section (example)
"(Hello)*(IF)" and replace with "". Is this possible to do a range in Excel to remove chunks of text in a cell ?.
A Macro would be perfect.
A formula is not ideal as i have multiple paragraphs i need to remove
Regards
I have a page of data in one particular cell (i imported an email into it). What i would like to do is remove many words between sentences so i am left with the data i require.
For example
Cell "A1" contains
Hello this is a test
Customer require
IF
Testing 123
etc,etc
I would like to only KEEP the words Testing 123.
In Word you can use a Range in the Find and Replace section (example)
"(Hello)*(IF)" and replace with "". Is this possible to do a range in Excel to remove chunks of text in a cell ?.
A Macro would be perfect.
A formula is not ideal as i have multiple paragraphs i need to remove
Regards
