Need the Accounts data to come to the next line dynamically within the cell.

[vba_life]

hii

I have attached an excel sheet for a clear demonstration of my problem.

Under the columns Accounts Debited,Accounts Credited,Amounts Debited and Amounts Credited few account numbers have been listed out.

All the Non-Standard Entries belong to one set of range and all Standard Entries belong to another set of range.

My problem here is for each cell under the above mentioned columns

for example;
In the 16 th row they are two account numbers under c column.

"123-456789+164-123456"

So these account numbers are coming in one line though they are two account numbers.
Each Account number is prefixed by a '+' sign.

I want it such a way that right after entering the first account number the second account number should come into the next line rather than manually pressing enter.

I need a macro which works invidually for each cell under and for all four columns.

This is the input:-(example 19th row,c column)

"111-123456+111-345678+111-112233+111-334455+111-456567+111-234567+121-765890+231-123456"


The output should come in this way:-

111-123456(first account number doesnt have "+" sign)
+111-345678(it should come in the next line rathar than in the same line in that particular cell dynamically along with the + symbol)
+111-112233
+111-334455
+111-456567
+111-234567
+121-765890
+231-123456


This is for ONE cell.The First account number doesnt have "+" sign. Only "+" starts with the second account number.

1.After it experiences with "+" symbol the next account number should come in the next line along with the "+" sign rathar than in the same line for both standard and non standard enteries under the 4 columns for each cells.

2.I need it in the form of a macro.

The input is given in the insert function box which is nothing but the f suffix x box.
The output should come is the cells likely.

Thank You.