How do I separate text without a space?
On Tue, 6 Mar 2007 16:01:13 -0800, trainer07
wrote:
In column A I have 10 different names listed. For example, in cell A1 I have
the name, JohnDoe. I would like to insert a space between the first and
last name. How would I do this for all the cells?
More complicated method:
Use this *array* entered formula:
=LEFT(A1,MATCH(TRUE,CODE(MID(A1,ROW(
INDIRECT("2:"&LEN(A1))),1))<=90,0))&" "&
MID(A1,1+MATCH(TRUE,CODE(MID(A1,ROW(
INDIRECT("2:"&LEN(A1))),1))<=90,0),255)
To enter an *array* formula, after entering the formula into the formula bar,
hold down <ctrl<shift while you hit <enter. Excel will place braces {...}
around the formula.
--ron
|