Posted to microsoft.public.excel.worksheet.functions

NBVC[_95_] NBVC[_95_] is offline

external usenet poster

Posts: 1

Separate text and replace characters

Try:

=LEFT(SUBSTITUTE(A1,".","-"),7)

and

=RIGHT(SUBSTITUTE(A1,".","-"),7)

--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116152

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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 two dates from a text string into two separate cells	Tacrier	Excel Discussion (Misc queries)	3	October 13th 08 08:53 PM
Replace non printable characters	TonyL	Excel Worksheet Functions	4	August 25th 07 01:03 PM
How to separate the numbers and characters in the cell	vino	Excel Worksheet Functions	3	August 23rd 06 01:47 PM
Separate characters in a string	viadisky	Excel Discussion (Misc queries)	2	February 1st 06 05:35 PM
Trying to truncate or separate the first 3 characters/digits of co	Jim	Excel Discussion (Misc queries)	4	January 13th 06 01:51 PM

All times are GMT +1. The time now is 03:46 PM.

About Us

"It's about Microsoft Excel"