• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

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 <=>?
0
gogoshar
Asked:
gogoshar
1 Solution
 
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
 
ben_staplesCommented:
Do you mean you want to use a formula which uses 'less than' or 'greater than'?

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
Saurabh Singh TeotiaCommented:
You can use something like this...

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

Saurabh...
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now