Posted to microsoft.public.excel.worksheet.functions

XMLCimo

Posts: n/a

Opposite of Concatenate (Breaking apart a string)

Hi have a cell that has the folowing string "Martini Glass, Appletini" and I
need to turn this one cell into two cells by finding the comma and taking
everythign after that to place it into another cell. So the value would be
"Martini Glass" in one cell and "Appletini" in another.

HELP!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opposite of Concatenate	shane24	Excel Worksheet Functions	6	December 2nd 05 12:14 PM
Breaking up a string into separate columns	Loz	Excel Worksheet Functions	5	November 22nd 05 03:08 AM
Opposite of Concatenate	Steve	Excel Worksheet Functions	2	September 1st 05 02:20 AM
superscript in part of a string when using concatenate	Ged2	Excel Discussion (Misc queries)	1	August 23rd 05 02:47 PM
Read Text File into Excel Using VBA	Willie T	Excel Discussion (Misc queries)	13	January 8th 05 12:37 AM

All times are GMT +1. The time now is 08:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us