Prefix i cell value with another cell value

H

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
1,226
Office Version
  1. 2010
Platform
  1. Windows
  2. Mobile
In cell D5:D9999 i get numerical values. I want to prefix it with column E5:E9999. Results in F5:F9999. How to accomplish?
Ex:
D5=190 E5=GGG-87 F5=GGG-87190
D6=19999 E5=gG-+5555 F5=gG-+555519999
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

V
  • Solved
Making winning teams in highlighted cells of the soccer table
Replies
2
Views
625
VKiprijan
V
V
  • Locked
  • Question Question
IF and AND function with COUNTIF to calculate only populated cells (continued)
Replies
1
Views
501
Joe4
Joe4
V
  • Question Question
Goals statistics
Replies
0
Views
319
VKiprijan
V
msword
  • Solved
=AVERAGE: How to exclude cell with errors completely?
Replies
4
Views
576
etaf
etaf
C
  • Solved
Countifs Number Of Times Team Play on each weekday
Replies
3
Views
284
CordingBags
C

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

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
Back
Top