开发者

Divide entire column in excel (accounting) in 2 separate column (symbol + value)

how to divide excel field with format account开发者_StackOverflow中文版ing omitted, for example: $ 220 € 140 $ 220 € 140 $ 220 € 140 $ 220 € 140 etc...etc... So, from one field-column A, to get 2 column A (for accounting symbol) and B (for value)?


You can do it like this:

First column:

Divide entire column in excel (accounting) in 2 separate column (symbol + value)

Second column:

Divide entire column in excel (accounting) in 2 separate column (symbol + value)

The first extracts a char from the beggining, and the second removes the first two displaying 100 chars ahead. You can convert the second column to number by wrapping the formula in a value().

Update:

If you know that will be a space between the two you can use this formulas instead and parse a more than one char accounting symbol:

=LEFT(A1;FIND(" ";A1))

=MID(A1;FIND(" ";A1)+1;100)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜