1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Replacing values in Excel with an X

    From PaddyStan@21:1/5 to All on Tue Nov 23 20:04:27 2021
    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.

    Thanks

    PaddyStan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ammammata@21:1/5 to All on Wed Nov 24 08:23:25 2021
    Il giorno Wed 24 Nov 2021 05:04:27a, *PaddyStan* ha inviato su microsoft.public.excel il messaggio news:[email protected]. Vediamo
    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.png

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From PaddyStan@21:1/5 to Ammammata on Thu Nov 25 14:23:02 2021
    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.


    https://i.imgur.com/G4xiAPs.png

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........
    Ammammata

    My apologies. I do not appear to be able to view your reply.

    Kindest regards

    PaddyStan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From PaddyStan@21:1/5 to PaddyStan on Thu Nov 25 19:21:49 2021
    On Friday, November 26, 2021 at 9:23:05 AM UTC+11, PaddyStan wrote:
    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.


    https://i.imgur.com/G4xiAPs.png

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........
    Ammammata

    My apologies. I do not appear to be able to view your reply.

    Kindest regards

    PaddyStan
    I think I've found it:

    Sub FindReplace()
    'Updateby Extendoffice
    Dim Rng As Range
    Dim WorkRng As Range
    On Error Resume Next
    xTitleId = "KutoolsforExcel"
    Set WorkRng = Application.Selection
    Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) For Each Rng In WorkRng
    If Rng.Value > 0 Then
    Rng.Value = "X"
    End If
    Next
    End Sub

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ammammata@21:1/5 to All on Fri Nov 26 08:08:52 2021
    Il giorno Thu 25 Nov 2021 11:23:02p, *PaddyStan* ha inviato su microsoft.public.excel il messaggio news:355e4464-2830-4edc-9c62- [email protected]. 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 command

    I just tested the link, it's working: maybe you can try with a smartphone
    or a different computer

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From PaddyStan@21:1/5 to Ammammata on Tue Nov 30 23:33:35 2021
    On Friday, November 26, 2021 at 7:08:57 PM UTC+11, Ammammata wrote:
    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 command

    I just tested the link, it's working: maybe you can try with a smartphone
    or a different computer
    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........
    Ammammata

    Your solution works perfectly!

    Many thanks.

    I've just posted another one.

    PaddyStan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)