Need opposite of excel function CONCATENATE
 

Is there an easy way to take a text phrase and parse it to extract the
seperate parts into individual cells? The Right, Mid and Left functions all
depend on the data being the same lenth, which is not true in the app I am
using.

The Mid with a Find works somewhat, but you cannot always make it work

Try DataText to columns

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Adam" wrote in message
...
Is there an easy way to take a text phrase and parse it to extract the
seperate parts into individual cells? The Right, Mid and Left functions
all
depend on the data being the same lenth, which is not true in the app I am
using.

The Mid with a Find works somewhat, but you cannot always make it work

Well, a couple of options.
First try the Data | Text to Columns feature. It's in the Data Menu.

Or, both of these formulas will adjust to the length of the data:

=RIGHT(B31,LEN(B31)-FIND(" ",B31))

=MID(B31,FIND(" ",B31)+1,LEN(B31)-FIND(" ",B31))

I've used these to separate first and last names where they are listed
Firstname Lastname.

tj

"Adam" wrote:

Is there an easy way to take a text phrase and parse it to extract the
seperate parts into individual cells? The Right, Mid and Left functions all
depend on the data being the same lenth, which is not true in the app I am
using.

The Mid with a Find works somewhat, but you cannot always make it work

"Adam" wrote in message
...
Is there an easy way to take a text phrase and parse it to extract the
seperate parts into individual cells? The Right, Mid and Left functions
all
depend on the data being the same lenth, which is not true in the app I am
using.

The Mid with a Find works somewhat, but you cannot always make it work


You can split data if you have something to split on.
http://www.ozgrid.com/Excel/split-excel-data.htm

/Fredrik