Need opposite of excel function CONCATENATE

[Guest]

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

 

[Niek Otten]

Try Data>Text to columns

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

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

 

[Fredrik Wahlgren]

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