Posted to microsoft.public.excel.misc

Dale G[_2_] Dale G[_2_] is offline

external usenet poster

Posts: 85

Split concatenation

Hi,
In cell A2, need to take this concatenated text and time string
510n0.240972222222222 and separate it in to cell B2 & C2. The left is the
text which I can get with =LEFT(A2,4) for my desired result of 510n. The
right I need to have in a time format like 5:47 that's where I'm stuck.

Any help is appreciated

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
concatenation	Charles Eaves	New Users to Excel	1	April 4th 09 04:16 PM
Concatenation	Nanapat	Excel Discussion (Misc queries)	4	December 13th 08 01:47 PM
How do I remove split a split window?	Norm	New Users to Excel	3	July 19th 08 10:31 PM
Concatenation	JPS	Excel Worksheet Functions	3	May 4th 08 07:35 AM
Concatenation	Harry	Excel Worksheet Functions	2	July 17th 06 07:17 PM

All times are GMT +1. The time now is 12:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us