excel: how do insert smth like <=> into excel. i need to be able to add text in <=>?

excel: how do insert smth like <=> into excel. i need to be able to add text in <=>?
gogosharAsked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
You can use something like this...

"<"& " Your Text here" &"=" & "Your text here" &">"

Saurabh...
0
 
Patrick MatthewsCommented:
Hello gogoshar,

Please have another go at explaining your question.

Regards,

Patrick
0
 
Saurabh Singh TeotiaCommented:
Lets say you write your text in A1...then apply this formula in B1 it will concatenate..

="<=>"&A1

Saurabh...
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
ben_staplesCommented:
Do you mean you want to use a formula which uses 'less than' or 'greater than'?

0
 
gogosharAuthor Commented:
sorry. I guess a better explanation would be:

I need to insert a big arrow smth like <=> that people can see in the spread sheet and write text in heart of the arrow (=)
0
 
ben_staplesCommented:
For adding lines in VBA, you can use the functions below:

replace StartX etc with numbers or variables
ActiveSheet.Shapes.AddLine(StartX, StartY, EndX, EndY).Select
Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadTriangle
Selection.ShapeRange.Line.EndArrowheadLength = msoArrowheadLengthMedium
Selection.ShapeRange.Line.EndArrowheadWidth = msoArrowheadWidthMedium
Selection.ShapeRange.Line.EndArrowheadLength = msoArrowheadLengthMedium
Selection.ShapeRange.Line.EndArrowheadWidth = msoArrowheadWidthMedium
Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadTriangle

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.