Follow this topic

Pawee Chiranothai

Last answered:

30 Aug 2021

Posted on:

27 Aug 2021

0

How do I replace formatting without removing the values/text?

in Introduction to Excel / Find and Replace - Formatting

I tried replacing the formats. It worked for the formatting, but the text disappeared. Seems like I did something wrong. Please suggest how to fix it.

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

30 Aug 2021

0

Hi Pawee,
Good to hear from you.
Did you adjust the font color to white, please?
Could you share a screenshot with the settings you opted for?
Best,
Ned

Submit an answer

related questions

2

8

find and replace

Charles Acheampong

0

6

Resolved: Custom cell formatting not working

0

6

Resolved: Issues with number stored as text

0

4

Text To column in excel problem

Jakob Bruhn Krøjgaard Skelmose

0

4

Resolved: How do i activate det find and replace function?

Daryl-Palma Asongu Nguatem

1

4

working with text on excel

0

4

Conditional Formatting

Alejandro Hasselmeyer

2

4

Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error

Ibrahim Ali Sayed Ahmed

0

2

Custom formatting

0

2

i want to attempt the formatting project in EXcel

0

2

I need more understanding on custom formatting.

Asmaa Abdulhamid

0

2

Why does the net income have opposite signs for the same values??