Use the > as text in formula

		Microsoft Office Forums > Microsoft Excel > Excel
Use the > as text in formula

10-24-2021, 01:55 AM

Marcia

Windows 10 Use the > as text in formula

Office 2019

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Quote:

Originally Posted by Pecoflyer

Perhaps inserting a tlde would help?
"~>"&"aaa"

I tried that tilde but the formula is still adding the values of all accounts with > in column A.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUM formula using text colours	trevorc	Excel	2	07-08-2021 09:19 PM
Help with Formula to extracting text from text string	Haha88	Excel	7	01-13-2019 01:33 AM
Help with Formula to extracting text from text string	Haha88	Excel	9	02-05-2018 01:04 AM
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
display text from formula	ketanco	Excel	1	04-24-2014 10:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:56 AM.