Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Separting negative numbers from letters in cells
3 views
Skip to first unread message
patatwork
May 15, 2013, 4:43:57 PM5/15/13
to
Okay I had to code data and possible values were as follows:
-2c
-2b
-2a
99
1a
1b
2
I accidently put them all in the same cell however I need the letters
and numbers in different cells (for example given |-2c| I would want to
output |-2|c| with the straight lines being cells). I know there were
other discussions on this issue, however, mine deals with actually
keeping the negative numbers so those formulas wouldn't work. Thanks in
advance for your help. FYI I am running Excel 2010 if that matters.
--
patatwork
Claus Busch
May 15, 2013, 5:06:59 PM5/15/13
to
Hi,
Am Wed, 15 May 2013 21:43:57 +0100 schrieb patatwork:
> Okay I had to code data and possible values were as follows:
> -2c
> -2b
> -2a
> 99
> 1a
> 1b
> 2
your values in column A. Then in B1:
=IF(ISTEXT(A1),--(LEFT(A1,LEN(A1)-1)),A1)
and in C1:
=IF(ISTEXT(A1),RIGHT(A1,1),"")
You can copy column B:C and pastespecial paste values and then delete
column A
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Am Wed, 15 May 2013 21:43:57 +0100 schrieb patatwork:
> Okay I had to code data and possible values were as follows:
> -2c
> -2b
> -2a
> 99
> 1a
> 1b
> 2
=IF(ISTEXT(A1),--(LEFT(A1,LEN(A1)-1)),A1)
and in C1:
=IF(ISTEXT(A1),RIGHT(A1,1),"")
You can copy column B:C and pastespecial paste values and then delete
column A
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0 new messages