Two solutions.
1. through a function
If the data is in Column A, Use this function in column B
=MID(A1,FIND("(",A1)+1,7)
2. Using Commands (Data -> Text to Columns
a. Select the data
b. Go to Data -> Text to Columns
c. Select Delimited Option
I have Done it with formula Check it if you have any other query
Arif Mansoorali Massani
Bhavnagar
Gujarat, India
M. +91-9913382099
On Wed, Aug 18, 2010 at 8:20 PM, Michael Hayes wrote:
> Alex,
>
> This a "Text to Columns" function. Select the column, use the Text to
> Columns/ delimited fu
Hi Alex,
Please check attached sheet..I think Your Problem has been solved.
Thanks,
Noorain Ansari
E-mail Id :noorain.ans...@gmail.com
On Wed, Aug 18, 2010 at 7:50 AM, Michael Hayes wrote:
> Alex,
>
> This a "Text to Columns" function. Select the column, use the Text to
> Columns/ delimited fu
Alex,
This a "Text to Columns" function. Select the column, use the Text to
Columns/ delimited function with "space" as an indicator.
In Excel 2007 "Text to Columns" can be found on the Data tab.
On Aug 18, 4:51 am, Alexander Cargill
wrote:
> Hi all I was wondering if you could help. I have a