x,y,z coordinates with single space "need tab"

gsrikanth · #1 07-07-2012, 05:14 AM

any macro in excel

if i past 383644 1983816 255
"space" replace "tab"
X in A1
Y IN B1
Z IN C1

Colin Legg · #2 07-07-2012, 08:16 AM

Use text to columns with a space delimiter.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wierd symbols inplace of "space", "indentation" etc	aka.bhagvanji	Word	5	02-16-2012 11:50 AM
Outlook 2007: "The drive that contains your data file is out of disk space....."	CLAWS	Outlook	1	12-18-2011 11:54 PM
The heading doesn't "obey" the "before" space! why?	Jamal NUMAN	Word	1	07-06-2011 04:25 AM
Replacing a single "l" with a double "ll"	MShroff	Word	8	01-19-2011 08:43 AM
Outlook 2007 - Receiving Multiple "read receipts" from a single email	garp2100	Outlook	1	12-03-2010 07:10 AM