Concatenate Or Text On Text Fields | MrExcel Message Board

Trang chủ » G2=h2+r2 » Concatenate Or Text On Text Fields | MrExcel Message Board

Có thể bạn quan tâm

MrExcel Message Board
  • Forums New posts Search forums Board Rules
  • What's new Featured content New posts New Excel articles Latest activity
  • New posts
  • Excel Articles Latest reviews Search Excel articles
  • MrExcel Publishing MrExcel Homepage MrExcel Bookstore MrExcel Seminars Excel Consulting Services
Log in Register What's new Search

Search

Everywhere Threads This forum This thread Search titles only Note By: Search Advanced search…
  • New posts
  • Search forums
  • Board Rules
Menu Log in Register Install the app Install How to install the app on iOS

Follow along with the video below to see how to install our site as a web app on your home screen.

Note: This feature may not be available in some browsers.

  • If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
  • Forums
  • Question Forums
  • Excel Questions
You are using an out of date browser. It may not display this or other websites correctly.You should upgrade or use an alternative browser. Concatenate or Text on Text fields
  • Thread starter Thread starter Ducati_John
  • Start date Start date Oct 16, 2006
D

Ducati_John

New Member
Joined Mar 15, 2006 Messages 12 Hi I have a spreadsheet that was designed to convert a 318 character string into appropriate fields. To preserve the original format and any line spaces this data is ALL save as TEXT I am attempting to now go backwards and convert this data back into its original single 318 character field. My issue is that when using either the concatenate or text function, it treats the formula as TEXT instead of a formula. =concatenate(A2,B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2,O2,P2,Q2,R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2) Have attempted to reformat this field into all the different options but with no success. I suspect the issue is related to the data that is stored as TEXT? Any assistance would be appreciated.

Excel Facts

Select all contiguous cells Click here to reveal answer Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions. Sort by date Sort by votes S

stanleydgromjr

Banned
Joined Jul 30, 2006 Messages 3,656 Assuming that the original text string was 'comma' separated, copy the below formula to a CELL in your spreadsheet: =CONCATENATE(A2&",",B2&",",C2&",",D2&",",E2&",",F2&",",G2&",",H2&",",I2&",",J2&",",K2&",",L2&",",M2&",",N2&",",O2&",",P2&",",Q2&",",R2&",",S2&",",T2&",",U2&",",V2&",",W2&",",X2&",",Y2&",",Z2&",",AA2&",",AB2&",",AC2&",",AD2&",") Then copy and Edit, Paste Special, Values, the CELL back onto itself. Hope this helps. Have a great day, Stan Upvote 0 A

acw

MrExcel MVP
Joined Feb 13, 2004 Messages 4,814 John Reformat the cell to General, then press F2, enter. That should make it show a result, not treat it as text. Basically, you have to format the cell back to general before you try to enter a formula. If you do it afterwards, then you have to edit the formula, and put it back in again. HTH Tony Upvote 0 You must log in or register to reply here.

Similar threads

A
  • Solved
Ignore Empty Cells?! Help!
  • Alex Caldecott
  • Nov 15, 2023
  • Excel Questions
Replies 3 Views 698 Nov 15, 2023 Fluff Fluff W
  • Solved
Using MIN with IF resulting in #VALUE error
  • Woftae
  • May 13, 2024
  • Excel Questions
2 Replies 15 Views 1K May 15, 2024 myall_blues myall_blues A
  • Question Question
Bullet Point List Formula Help....
  • Alex Caldecott
  • Apr 26, 2024
  • Excel Questions
Replies 1 Views 359 Apr 26, 2024 Fluff Fluff S
  • Locked
  • Question Question
Formula Lenght
  • Stanman
  • Oct 13, 2022
  • Excel Questions
Replies 1 Views 581 Oct 13, 2022 Peter_SSs Peter_SSs SaraWitch
  • Solved
Extract individual lines from cell
  • SaraWitch
  • Jan 28, 2024
  • Excel Questions
Replies 6 Views 575 Jan 29, 2024 SaraWitch SaraWitch Share: Facebook X (Twitter) LinkedIn Reddit Tumblr WhatsApp Email Share Link

Forum statistics

Threads 1,225,166 Messages 6,183,292 Members 453,155 Latest member joncaxddd

Share this page

Facebook X (Twitter) LinkedIn Reddit Tumblr WhatsApp Email Share Link
  • Forums
  • Question Forums
  • Excel Questions

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 AdBlock1)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 Plus1)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 Origin1)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 uBlock1)Click on the icon in the browser’s toolbar.2)Click on the "Power" button.3)Click on the "Refresh" button. Go back Continue without adsI've disabled my adblock Back Top

Từ khóa » G2=h2+r2