# Take out USD in a cell

I have a column of cells that have "USD " then a dollar amount. How can I have a column right next to it that will only have the number? The number is in the form "123.45" or if it is a credit it is "(60.00)".

For example

USD 123.45
USD (60.00)

I want the USD and space after deleted. Thanks!
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Select that cell where you want this to appear..then

Press ctrl+1 -->Format cells-->custom-->then paste the below formatting

[\$USD] #,##0.00_);([\$USD] #,##0.00)

Hit Ok and you are good to go...

Saurabh...

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Microsoft Excel ExpertCommented:
Press ctrl+1 -->Format cells-->custom-->then paste the below formatting
same as above,

but then select Currency then select USD in Symbol and then click ok.
Finance AnalystCommented:
Assuming Values in column A and you want result in column B, use formula:

=VALUE(RIGHT(A1,LEN(A1)-4))

Then format as required.

Thanks
Rob H
Microsoft Excel ExpertCommented:
I think , I & Saurabh got the question incorrectly. Or perhaps the question was changed :-)
How come two person would miss this. We understood it in the opposite way.

Rob formula works but here is a non formula approach

In home tab go to replace then in find field put USD with its space in replace field put nothing and click replace all and then al of USD with its space will disappear
Finance AnalystCommented:
Alternative with non formula driven but still meets the request for it being in the next column.

Copy the column of values and paste into the next column, while that column/cells are still selected do the find and replace as suggested above.

Find:  "USD "       (with space)
Replace:               (leave blank)

With the cells selected, the replace will only affect those selected.
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.