Excel Formula Issue

Is there a way to get a line break in place of the dash in the formula below?

B4&"-"&"$"&ROUND(C4,1)

I would want 1424-$6.3
 to look like
1424
$6.3
LVL 7
tomfarrarAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Try this...
=B4&CHAR(10)&"$"&ROUND(C4,1)

Open in new window

Enable Wrap Text in the formula cell also.
1
 
tomfarrarAuthor Commented:
That did the job..  Thanks, Subodh.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Tom!
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.