I have an Excel spreadsheet with values in certain cells, but not all
- the rest are blank.
I want to replace ONLY those with a value with an 'X'. The blank ones
I want to leave blank.
Please advise.
Il giorno Wed 24 Nov 2021 05:04:27a, *PaddyStan* ha inviato su microsoft.public.excel il messaggio
cosa ha scritto:
I have an Excel spreadsheet with values in certain cells, but not all
- the rest are blank.
I want to replace ONLY those with a value with an 'X'. The blank ones
I want to leave blank.
Please advise.
https://i.imgur.com/G4xiAPs.pngAmmammata
--
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........
On Wednesday, November 24, 2021 at 7:23:30 PM UTC+11, Ammammata wrote:
Il giorno Wed 24 Nov 2021 05:04:27a, *PaddyStan* ha inviato su microsoft.public.excel il messaggio
cosa ha scritto:
I have an Excel spreadsheet with values in certain cells, but not all
- the rest are blank.
I want to replace ONLY those with a value with an 'X'. The blank ones
I want to leave blank.
Please advise.
I think I've found it:https://i.imgur.com/G4xiAPs.png
--Ammammata
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........
My apologies. I do not appear to be able to view your reply.
Kindest regards
PaddyStan
https://i.imgur.com/G4xiAPs.png
My apologies. I do not appear to be able to view your reply.
Il giorno Thu 25 Nov 2021 11:23:02p, *PaddyStan* ha inviato su microsoft.public.excel il messaggio news:355e4464-2830-4edc-9c62-
Vediamo cosa ha scritto:
https://i.imgur.com/G4xiAPs.png
My apologies. I do not appear to be able to view your reply.
my reply it's a screenshot with some data and a find&replace commandAmmammata
I just tested the link, it's working: maybe you can try with a smartphone
or a different computer
--
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (3 / 13) |
Uptime: | 71:49:58 |
Calls: | 6,657 |
Calls today: | 3 |
Files: | 12,203 |
Messages: | 5,332,233 |
Posted today: | 1 |