separate cell numbers and text into separate cells.

February 17, 2012 at 21:04:44
Specs: Windows 7
need to separate this cell (fees=$6,552.00 exps=$3,428.72 2/7-2/20/10) with the dollar amounts into separate cells, Thanks in advance for any assistance.

See More: separate cell numbers and text into separate cells.

Report •


#1
February 18, 2012 at 00:22:15
Data...Text-To-Columns...Delimited

Click Next

Click the box next to Space

Put = in the Other box

Click Finish

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 18, 2012 at 13:04:56
Derby maybe a little more work to separate the text amount to numeric. Depends what is meant by 'dollar amount'.

Report •

#3
February 18, 2012 at 16:07:47
I guess we'll just have to wait for the OP to respond.

As of now, I was able to separate the "monetary" amounts using my suggestion and then sum them to get $9,980.72 with no extra formatting.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
February 20, 2012 at 09:46:28
Thanks everyone for the suggestions, not looking to total them just seperate them out as there are two dollar amounts in one cell and need to seperate those into separate columns and separate from the text also,
What I mean by dollar amounts is like $3333.33 there two in the column with text, I want to separate those dollar amounts in separate cells each, and also separate the text in a separate cell. Thanks again for your help. due to traveling it may be tomorrow before I can try your suggestions. Thanks

Report •


Ask Question