Make in to single row in exce;
Closed
HARY
-
Dec 18, 2015 at 12:08 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Dec 18, 2015 at 02:09 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Dec 18, 2015 at 02:09 PM
Related:
- Make in to single row in exce;
- Which key is used to make multiple line in a single cell - Guide
- Saints row 2 cheats - Guide
- How to delete row in word - Guide
- Single beep sound in cpu - Guide
- We can keep multiple version of a word document in a single file by using - Guide
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Dec 18, 2015 at 02:09 PM
Dec 18, 2015 at 02:09 PM
With your data in columns A, B and C.
In D1, =CONCATENATE(A1,B1,C1)
Then in D2: =CONCATENATE(D1,A2,B2,C2)
copy this formula down through the rest of the rows.
Each result will get longer the further you go down.
Its not pretty but its quick and easy.
In D1, =CONCATENATE(A1,B1,C1)
Then in D2: =CONCATENATE(D1,A2,B2,C2)
copy this formula down through the rest of the rows.
Each result will get longer the further you go down.
Its not pretty but its quick and easy.