substitute - Search Results - Excel Help Forum

The value in vlookup array has spaces but the lookup value does not

Started by Allan91‎, 03-26-2024 04:12 AM

excel formulas, remove spaces, substitute, trim, vlookup

4

110

Last Post By:: Last Post: 03-26-2024 07:17 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] VBA to Remove Last Occurrence of a Full Stop in a String

Started by mowens74‎, 10-25-2023 07:15 AM

last occurrence, substitute, vba & excel

1

205

Last Post By:: Last Post: 10-25-2023 08:14 AM; by davesexcel

Forum:
Excel Programming / VBA / Macros

[SOLVED] Text in column D - Search for keywords, replace with GAP and place keyword in column E

Started by codeBeast‎, 05-05-2023 11:46 AM

36

621

Last Post By:: Last Post: 05-06-2023 05:16 AM; by codeBeast

Forum:
Excel Programming / VBA / Macros

Replace a certain part (name of excel file with another excel file) within a formula

Started by ek004‎, 04-20-2023 07:11 AM

function, replace, search & replace, substitute

5

314

Last Post By:: Last Post: 04-27-2023 09:24 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] VBA code to replace "1" with "7:00/ 15:30"

Started by GLV‎, 03-24-2023 08:16 AM

9

437

Last Post By:: Last Post: 03-25-2023 07:03 AM; by GLV

Forum:
Excel Programming / VBA / Macros

[SOLVED] Music Chord Transpose

Started by Jaimeriz06‎, 02-14-2023 03:53 PM

google sheets, guitar, index, music, substitute

5

1,148

Last Post By:: Last Post: 02-17-2023 03:06 AM; by Jaimeriz06

Forum:
For Other Platforms(Mac, Google Docs, Mobile OS etc)

SUBSTITUTE/IF Formula for specified and unspecified text in cells

Started by jakemoggy77‎, 11-11-2022 11:58 AM

formula, if formula, if forumla, substitute, substitute formula

6

539

Last Post By:: Last Post: 11-24-2022 01:41 PM; by jakemoggy77

Forum:
Excel Formulas & Functions

Excel VBA UDF to find and substitute substring, with wildcards, from text string. Help

Started by infottico‎, 05-22-2022 10:25 PM

6

363

Last Post By:: Last Post: 05-23-2022 01:00 PM; by JEC.

Forum:
Excel Programming / VBA / Macros

Building A DYNAMIC FORMULA (to Simplify Relations) [SUBSTITUTE, LEN,..]

Started by Nic001‎, 04-29-2022 05:38 AM

building dynamic formula, countif, len, search, substitute

11

610

Last Post By:: Last Post: 05-05-2022 09:34 AM; by Nic001

Forum:
Excel Formulas & Functions

Removing apostrophes at the beginning of a line without removing the others.

Started by Christina81‎, 04-21-2022 01:18 AM

3

324

Last Post By:: Last Post: 04-21-2022 09:16 AM; by nick.williams

Forum:
Excel Formulas & Functions

Need help returning specific text value based on criteria

Started by charlesny09‎, 03-18-2022 11:02 PM

excel, if formulas, nest formulas, substitute

7

292

Last Post By:: Last Post: 03-19-2022 12:13 AM; by charlesny09

Forum:
Excel Formulas & Functions

[SOLVED] Substitute formula and column sorting question

Started by walkerneedshelp‎, 11-23-2021 12:53 AM

1

281

Last Post By:: Last Post: 11-23-2021 05:45 AM; by mehmetcik

Forum:
Excel Formulas & Functions

[SOLVED] Replace the word "bb" in Column B with "cc", if "aa" is found in Column A

Started by isend‎, 11-20-2021 12:46 PM

4

331

Last Post By:: Last Post: 11-20-2021 01:40 PM; by mehmetcik

Forum:
Excel Formulas & Functions

Conditional Format with formula (fill-right, drag formula)

Started by jaykum‎, 08-10-2021 01:44 AM

conditional format errors, indirect address, offset column, substitute

2

325

Last Post By:: Last Post: 08-10-2021 05:09 AM; by jaykum

Forum:
Excel Formulas & Functions

[SOLVED] VBA Count Number Of Specific Strings in a Cell

Started by mowens74‎, 07-09-2021 02:33 AM

3

414

Last Post By:: Last Post: 07-21-2021 08:14 AM; by mowens74

Forum:
Excel Programming / VBA / Macros

Count no. of words in cell, put 0 for blanks

Started by rayted‎, 05-13-2021 04:48 AM

1

298

Last Post By:: Last Post: 05-13-2021 04:58 AM; by Phuocam

Forum:
Excel Formulas & Functions

How to replace " from a Text?

Started by Sybon‎, 05-02-2021 07:54 AM

clean, replace, special character, substitute

10

498

Last Post By:: Last Post: 05-02-2021 03:23 PM; by Rick Rothstein

Forum:
Excel Formulas & Functions

[SOLVED] Trying to remove two text strings with one formula - possible nesting issue

Started by Just Visiting‎, 02-23-2021 06:07 PM

5

495

Last Post By:: Last Post: 02-24-2021 10:50 AM; by TMS

Forum:
Excel Formulas & Functions

[SOLVED] #VALUE! Error Using a Triple Nested SUBSTITUTE Formula, ERROR DUE TO EMPTY CELL(S)

Started by skite0‎, 02-23-2021 03:53 PM

#value!, formula, substitute, sum - range of cells

3

407

Last Post By:: Last Post: 02-23-2021 04:13 PM; by Fluff13

Forum:
Excel Formulas & Functions

Substitute final vowel of text string

Started by Henry54289‎, 12-27-2020 01:05 PM

8

837

Last Post By:: Last Post: 12-28-2020 06:10 AM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

Excel Replace/Substitute Problem

Started by anonymous321‎, 12-19-2020 11:38 PM

9

1,443

Last Post By:: Last Post: 12-20-2020 11:33 PM; by anonymous321

Forum:
Excel General

Excel Substitution Problem

Started by anonymous321‎, 12-17-2020 10:05 PM

2

602

Last Post By:: Last Post: 12-17-2020 10:54 PM; by anonymous321

Forum:
Excel General

Conversion of formula to DAX / PowerPivot

Started by Phil123456789‎, 11-23-2020 09:55 AM

4

862

Last Post By:: Last Post: 11-23-2020 11:39 AM; by Phil123456789

Forum:
Excel Formulas & Functions

[SOLVED] How to combine IFERROR VLOOKUP SUBSTITUTE Function Across Multiple Tables

Started by jerung3000‎, 07-22-2020 12:21 PM

formulas, function, iferror, substitute, vlookup

1

811

Last Post By:: Last Post: 07-22-2020 12:28 PM; by jerung3000

Forum:
Excel Formulas & Functions

Shorter substitute formula in excel

Started by mehidy1437‎, 07-16-2020 12:28 AM

2

346

Last Post By:: Last Post: 07-16-2020 12:56 AM; by mehidy1437

Forum:
Excel Formulas & Functions

[SOLVED] Problem converting text to Excel date using LEFT and SUBSTITUTE

Started by jrtaylor‎, 06-29-2020 03:18 PM

datevalue, left, substitute, text to number

8

381

Last Post By:: Last Post: 06-29-2020 05:23 PM; by jrtaylor

Forum:
Excel Formulas & Functions

Substitute/Replace Then Extract

Started by Sparky42PT‎, 05-20-2020 05:10 PM

3

487

Last Post By:: Last Post: 05-21-2020 09:03 AM; by Fluff13

Forum:
Excel Formulas & Functions

Countif and Countifs help

Started by kevgdob‎, 03-11-2020 08:14 AM

18

835

Last Post By:: Last Post: 03-14-2020 04:07 PM; by pernekde

Forum:
Excel Formulas & Functions

[SOLVED] Extracting the first word form every cell in a column

Started by mikeymeteora‎, 01-28-2020 08:12 AM

12

535

Last Post By:: Last Post: 01-29-2020 12:23 AM; by Rick Rothstein

Forum:
Excel Programming / VBA / Macros

[SOLVED] Counting a specific character string in a range of cells.

Started by juansalix‎, 11-18-2019 09:39 AM

3

443

Last Post By:: Last Post: 11-18-2019 10:02 AM; by AliGW

Forum:
Excel General

Alternate cell substitution based on condition

Started by phodges‎, 07-01-2019 01:52 AM

8

1,060

Last Post By:: Last Post: 07-01-2019 10:43 PM; by David A Coop

Forum:
Excel General

[SOLVED] Removing text strings based on multiple matches

Started by kaiming‎, 06-27-2019 04:53 AM

7

660

Last Post By:: Last Post: 07-04-2019 10:30 AM; by FlameRetired

Forum:
Excel Formulas & Functions

[SOLVED] Replace with whole word match only?

Started by JP Romano‎, 10-29-2018 02:26 PM

5

833

Last Post By:: Last Post: 10-29-2018 05:26 PM; by TMS

Forum:
Excel Programming / VBA / Macros

Trying To Extract Multiple, Same Phrases Out Of A Cell

Started by ExcelStudent751‎, 09-19-2018 09:38 AM

extract, mid, multiple, search, substitute

6

758

Last Post By:: Last Post: 09-19-2018 12:15 PM; by Bosco

Forum:
Excel Formulas & Functions

[SOLVED] substitute gives a #NAME? error

Started by jrtaylor‎, 01-31-2018 08:26 PM

3

604

Last Post By:: Last Post: 02-05-2018 11:19 AM; by jrtaylor

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds.

The value in vlookup array has spaces but the lookup value does not

[SOLVED] VBA to Remove Last Occurrence of a Full Stop in a String

[SOLVED] Text in column D - Search for keywords, replace with GAP and place keyword in column E

Replace a certain part (name of excel file with another excel file) within a formula

[SOLVED] VBA code to replace "1" with "7:00/ 15:30"

[SOLVED] Music Chord Transpose

SUBSTITUTE/IF Formula for specified and unspecified text in cells

Excel VBA UDF to find and substitute substring, with wildcards, from text string. Help

Building A DYNAMIC FORMULA (to Simplify Relations) [SUBSTITUTE, LEN,..]

Removing apostrophes at the beginning of a line without removing the others.

Need help returning specific text value based on criteria

[SOLVED] Substitute formula and column sorting question

[SOLVED] Replace the word "bb" in Column B with "cc", if "aa" is found in Column A

Conditional Format with formula (fill-right, drag formula)

[SOLVED] VBA Count Number Of Specific Strings in a Cell

Count no. of words in cell, put 0 for blanks

How to replace " from a Text?

[SOLVED] Trying to remove two text strings with one formula - possible nesting issue

[SOLVED] #VALUE! Error Using a Triple Nested SUBSTITUTE Formula, ERROR DUE TO EMPTY CELL(S)

Substitute final vowel of text string

Excel Replace/Substitute Problem

Excel Substitution Problem

Conversion of formula to DAX / PowerPivot

[SOLVED] How to combine IFERROR VLOOKUP SUBSTITUTE Function Across Multiple Tables

Shorter substitute formula in excel

[SOLVED] Problem converting text to Excel date using LEFT and SUBSTITUTE

Substitute/Replace Then Extract

Countif and Countifs help

[SOLVED] Extracting the first word form every cell in a column

[SOLVED] Counting a specific character string in a range of cells.

Alternate cell substitution based on condition

[SOLVED] Removing text strings based on multiple matches

[SOLVED] Replace with whole word match only?

Trying To Extract Multiple, Same Phrases Out Of A Cell

[SOLVED] substitute gives a #NAME? error