Find and Replace

[blando89]

Hello everyone!!

Question is there a way when i do find and replace if i can find and replace a list?

Example:
Find: 4.5k 5.0k 6.0k
Replace: 4,500 5,000 6,000

Its just a lot of work to go through each one. I know i can find all of 4.5k and replace ALL at the same time but was wondering if i can do a list and replace all at the same time.

Hopefully i did not lose you.

Thanks!

[63falcondude]

What about changing k to 00 and changing . to , ?

[blando89]

So the list i have the salary shows 4.5k and i need to change everything that has k with currency. So 4,500 but i have to do a lot on all different types. 5.0k etc

[63falcondude]

So the list i have the salary shows 4.5k and i need to change everything that has k with currency. So 4,500 but i have to do a lot on all different types. 5.0k etc

Is the 4.5k formatted to show that way or is the value in the cell "4.5k". To check this, click on the cell and look in the formula bar. Does it show "4.5k" or "4500"?

[blando89]

The text shows $6.4k and the drop down under Number is GENERAL

[63falcondude]

The text shows $6.4k and the drop down under Number is GENERAL

Try my suggestion in post #2.

[blando89]

Oh that works and thats what i have to do but when i go to Ctrl-H to do the fine and replace i do find 4.5k and replace it with 4,500.

But what i am trying to figure is there a way i can do more than one
example
Fine: 4.5k and 5.0k
Replace 4,500 and 5,000

[63falcondude]

Oh that works and thats what i have to do but when i go to Ctrl-H to do the fine and replace i do find 4.5k and replace it with 4,500.

But what i am trying to figure is there a way i can do more than one
example
Fine: 4.5k and 5.0k
Replace 4,500 and 5,000

2 steps.

Find: .
Replace with: ,

Find: k
Replace with: 00

[blando89]

That worked! Oh man thank you! Just saved me so much time lol

[63falcondude]

Glad to help.