Separting negative numbers from letters in cells

P

patatwork

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 letter
and numbers in different cells (for example given |-2c| I would want t
output |-2|c| with the straight lines being cells). I know there wer
other discussions on this issue, however, mine deals with actuall
keeping the negative numbers so those formulas wouldn't work. Thanks i
advance for your help. FYI I am running Excel 2010 if that matters
 
C

Claus Busch

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top