Posted to microsoft.public.excel.programming

alldreans

external usenet poster

Posts: 1

splitting a cell into 2

Hello,

I can't figure this one out. Via a web query, I get a
value for H2 of "1,926.09 - 1,954.62".

I'd like to, through VBA, split the value in H2 and
paste them into 2 cells, I2 and J2. The f'inal result
would be I2 = "1,926.09" and J2 = "1,954.62".

Can anyone help me?

Thanks in advance

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
splitting my cell	rodchar	Excel Discussion (Misc queries)	5	July 22nd 08 03:24 PM
Splitting a cell	jayfin	New Users to Excel	6	December 19th 07 04:05 AM
Splitting a Cell	williamr	Excel Worksheet Functions	2	June 13th 07 01:30 AM
splitting a cell	wnfisba	Excel Discussion (Misc queries)	7	April 10th 07 10:22 AM
Splitting a Cell	c	Excel Worksheet Functions	5	April 11th 05 10:23 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us