software

I am trying to split data from one cell to another, I tried using the TEXT To
COLUMNS wizard but it wants to split the cell as a formula instead of the
value.

A1 =Sheet1!A1
A1 displays the value (please,help)

How can I split the value of A1 into A2 and A3?

Any help is greatly appriciated. Thanks.

Try these text formulas:

In B1,
=LEFT(A1,FIND(quot;,quot;,A1)-1)

In C1,
=RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Gabequot; gt; wrote in message
...
gt; I am trying to split data from one cell to another, I tried using the TEXT
To
gt; COLUMNS wizard but it wants to split the cell as a formula instead of the
gt; value.
gt;
gt; A1 =Sheet1!A1
gt; A1 displays the value (please,help)
gt;
gt; How can I split the value of A1 into A2 and A3?
gt;
gt; Any help is greatly appriciated. Thanks.Change column A to values first

Select column A, then Copy
Editgt;Pastespecialgt;Values

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Gabequot; gt; wrote in message
...
gt; I am trying to split data from one cell to another, I tried using the TEXT
To
gt; COLUMNS wizard but it wants to split the cell as a formula instead of the
gt; value.
gt;
gt; A1 =Sheet1!A1
gt; A1 displays the value (please,help)
gt;
gt; How can I split the value of A1 into A2 and A3?
gt;
gt; Any help is greatly appriciated. Thanks.
That worked pretty good, but now my format is messed up? I'm looking to
prefix the result with an quot;Equot; how would I do that? Before I just used a
custom format of quot;Equot;#### that worked pretty good but when I use the formula
it doesn't work. How can prefix it with an quot;Equot; for the following?

A1 =Sheet1!A1
A1 displays the value (GE00205189)
B1 =RIGHT(A1,4)
B1 displays the value (5189)

Thanks.

quot;RagDyerquot; wrote:

gt; Try these text formulas:
gt;
gt; In B1,
gt; =LEFT(A1,FIND(quot;,quot;,A1)-1)
gt;
gt; In C1,
gt; =RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1))
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt; ==============================================
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ==============================================
gt;
gt;
gt; quot;Gabequot; gt; wrote in message
gt; ...
gt; gt; I am trying to split data from one cell to another, I tried using the TEXT
gt; To
gt; gt; COLUMNS wizard but it wants to split the cell as a formula instead of the
gt; gt; value.
gt; gt;
gt; gt; A1 =Sheet1!A1
gt; gt; A1 displays the value (please,help)
gt; gt;
gt; gt; How can I split the value of A1 into A2 and A3?
gt; gt;
gt; gt; Any help is greatly appriciated. Thanks.
gt;
gt;

=quot;Equot;amp;LEFT(A1,FIND(quot;,quot;,A1)-1)

=quot;Equot;amp;RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Gabequot; gt; wrote in message
...
gt; That worked pretty good, but now my format is messed up? I'm looking to
gt; prefix the result with an quot;Equot; how would I do that? Before I just used a
gt; custom format of quot;Equot;#### that worked pretty good but when I use the
formula
gt; it doesn't work. How can prefix it with an quot;Equot; for the following?
gt;
gt; A1 =Sheet1!A1
gt; A1 displays the value (GE00205189)
gt; B1 =RIGHT(A1,4)
gt; B1 displays the value (5189)
gt;
gt; Thanks.
gt;
gt; quot;RagDyerquot; wrote:
gt;
gt; gt; Try these text formulas:
gt; gt;
gt; gt; In B1,
gt; gt; =LEFT(A1,FIND(quot;,quot;,A1)-1)
gt; gt;
gt; gt; In C1,
gt; gt; =RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1))
gt; gt;
gt; gt; --
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt; ==============================================
gt; gt; Please keep all correspondence within the Group, so all may benefit!
gt; gt; ==============================================
gt; gt;
gt; gt;
gt; gt; quot;Gabequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I am trying to split data from one cell to another, I tried using the
TEXT
gt; gt; To
gt; gt; gt; COLUMNS wizard but it wants to split the cell as a formula instead of
the
gt; gt; gt; value.
gt; gt; gt;
gt; gt; gt; A1 =Sheet1!A1
gt; gt; gt; A1 displays the value (please,help)
gt; gt; gt;
gt; gt; gt; How can I split the value of A1 into A2 and A3?
gt; gt; gt;
gt; gt; gt; Any help is greatly appriciated. Thanks.
gt; gt;
gt; gt;
=quot;Equot;amp;RIGHT(A1,4)

Regards
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498065The cell currently outputs a text string that looks like a number, so it is
formatted as text (a format like quot;Equot;#### applys only to numbers).

You have three options.

I. Change the formula to output a number.
=VALUE(RIGHT(A1,4))
and use the same custom number format of
quot;Equot;####

II. Leave the formula alone
=RIGHT(A1,4)
and change the format to something like
#;-#;0;quot;Equot;@

II. Change the formula to output a text string that includes quot;Equot;.
=quot;Equot;amp;RIGHT(A1,4)
and format as
general

quot;Gabequot; wrote:

gt; That worked pretty good, but now my format is messed up? I'm looking to
gt; prefix the result with an quot;Equot; how would I do that? Before I just used a
gt; custom format of quot;Equot;#### that worked pretty good but when I use the formula
gt; it doesn't work. How can prefix it with an quot;Equot; for the following?
gt;
gt; A1 =Sheet1!A1
gt; A1 displays the value (GE00205189)
gt; B1 =RIGHT(A1,4)
gt; B1 displays the value (5189)
gt;
gt; Thanks.
gt;
gt; quot;RagDyerquot; wrote:
gt;
gt; gt; Try these text formulas:
gt; gt;
gt; gt; In B1,
gt; gt; =LEFT(A1,FIND(quot;,quot;,A1)-1)
gt; gt;
gt; gt; In C1,
gt; gt; =RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1))
gt; gt;
gt; gt; --
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt; ==============================================
gt; gt; Please keep all correspondence within the Group, so all may benefit!
gt; gt; ==============================================
gt; gt;
gt; gt;
gt; gt; quot;Gabequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I am trying to split data from one cell to another, I tried using the TEXT
gt; gt; To
gt; gt; gt; COLUMNS wizard but it wants to split the cell as a formula instead of the
gt; gt; gt; value.
gt; gt; gt;
gt; gt; gt; A1 =Sheet1!A1
gt; gt; gt; A1 displays the value (please,help)
gt; gt; gt;
gt; gt; gt; How can I split the value of A1 into A2 and A3?
gt; gt; gt;
gt; gt; gt; Any help is greatly appriciated. Thanks.
gt; gt;
gt; gt;