LinkBack URL
About LinkBacks
Dear all,
How do I merge text fields of 3 different columns into 1 field?
For example:
A1: 120071
B1: 15
C1: 000
D1: all 3 fields must be pasted to become: 12007115000
What if I would like a dot in between each field? --> 120071.15.000
Thanks!
Dear all,
How do I merge text fields of 3 different columns into 1 field?
For example:
A1: 120071
B1: 15
C1: 000
D1: all 3 fields must be pasted to become: 12007115000
What if I would like a dot in between each field? --> 120071.15.000
Thanks!
You can use this formula to create a text string of those values:
=A1 & B1 & C1
If you want them to be an actual number, then use:
=(A1 & B1 & C1) + 0
Lastly, for the periods (which will result in a text string):
=A1 & "." & B1 & "." & C1
NOTE: You will need to format those cells as General for the formulas to work.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I think you have posted this on the wrong board. This is OUTLOOK programming I suspect you meant Excel Worksheet functions.Originally Posted by Mr DV
If so then = A1 & B1 & C1
or =A1 & "." & B1 & "." & C1
click on the * Add Reputation if this was useful or entertaining.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks