Use the > as text in formula

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

FAQ

Thread Tools

Display Modes

10-23-2021, 05:36 PM

Marcia

Windows 10 Use the > as text in formula

Office 2019

Expert

Join Date: May 2018

Location: Philippines

Posts: 527

Use the > as text in formula

Hi. Column A of a table has:
Travel
>aaa
>bbb
The values with the greater than symbol represent sub accounts. A problem came up when there is a SUMIF formula with column A as reference. It is reading the ">aaa" as greater than aaa.
How do I make the formula to read it as a plain character?
Thank you.

« Previous Thread | Next Thread »

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 02:27 PM.