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 m99pan...@gmail.com wrote:
Alex,
This a Text to Columns function. Select the column, use the Text to
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 m99pan...@gmail.com wrote:
Alex,
This a Text to Columns function. Select the column, use the Text to
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 and
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 zanderman1...@googlemail.com
wrote:
Hi all I was wondering if you