Posted to microsoft.public.excel.programming

Johnny[_6_] Johnny[_6_] is offline

external usenet poster

Posts: 1

Separate String into string + value form

If I have a string " tree1234 ". How can I separate it
into 2 cells " tree " and the most important the " 1234 "
should be in value format. Pls advise.

Johnny

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
separate string	Rick	Excel Discussion (Misc queries)	8	February 14th 09 03:37 AM
separate two dates from a text string into two separate cells	Tacrier	Excel Discussion (Misc queries)	3	October 13th 08 08:53 PM
separate numbers out of string	joesf16	Excel Worksheet Functions	3	May 2nd 07 07:15 AM
Separate a String of #'s	Coal Miner	Excel Worksheet Functions	4	July 10th 06 04:47 PM
Separate characters in a string	viadisky	Excel Discussion (Misc queries)	2	February 1st 06 05:35 PM

All times are GMT +1. The time now is 11:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us