Posted to microsoft.public.excel.programming

exceluserforeman exceluserforeman is offline

external usenet poster

Posts: 45

macor to split cells

here is the onsheet formula
123456 excel is easy 123456-excel is easy

C7 = 123456-excel is easy
A7 = =LEFT(C7,6)
B7 = =MID(C7,8,LEN(C7)-6)

" wrote:

Hello
I was wondering if anyone knows of a macro that will split the cells in
excel. I have a cell with 6 numbersm then a dash, then words and would like
to split it into two cells, one witht the numbers and one with the words. Any
ideas? Thanks a lot!

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
Help with Macor	gsxith3	New Users to Excel	1	August 2nd 08 01:31 PM
Macor	JakeShipley2008	Excel Discussion (Misc queries)	3	June 21st 07 04:40 PM
master macor	Neil	Excel Discussion (Misc queries)	1	March 2nd 07 04:39 PM
How to create a macor to count the usage of another macor	Jigu	Excel Discussion (Misc queries)	0	March 11th 06 03:28 AM
end sub in If then macor	P. Blaauw	Excel Programming	3	September 20th 03 05:25 PM

All times are GMT +1. The time now is 01:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us