Simple Question

T

tphillips

Board Regular
Joined
Jan 28, 2003
Messages
76
I want a cell to display the numerical value of another cell plus a text string after the number. Can this be done?

Thanks,
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
lenze

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Yes
If the number is in A1 and the text in A2, then in A3 enter

=A1&" "&A2

Depending on your real needs, there may be a better way using formatting or some other technique

lenze
 
Upvote 0
P

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
also, review the excel help file for 'Create a custom number format', in particular 'About number format codes for text and spacing'
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
(VBA) Range.Value = String still returns numeric
Replies
4
Views
125
gifariz
G
J
  • Solved
Sum Total Value of a Single Cell
2 3
Replies
28
Views
904
FormR
FormR
G
  • Solved
VBA - Quick tweak to an old solved&closed thread
Replies
4
Views
178
Alex Blakenburg
A
S
  • Question
Conditional Formatting Formula
2 3
Replies
20
Views
353
Fluff
Fluff
RoyalRife
  • Question
Excel is hard... I tell you hwhat!
Replies
2
Views
131
RoyalRife
RoyalRife

Forum statistics

Threads
1,195,664
Messages
6,011,015
Members
441,579
Latest member
satishrazdhan

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top