| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I move this data?
I have some excel data that I need to merge into one cell... for
example ADDR1-ST Num ADDR1-ST Name 111 E MAIN ST I want to put it all in one cell ADDR1-ST Name 111 E MAIN ST I have about 15,000 records so I want the [SPACE] between the Number and the Name any ideas? thanks. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I move this data?
If the first address is in A2:B2 then this should work =A2&" "&B2
But your data as some hard-spaces after the 111 (this could have resulted from the email) so you may need to use =SUBSTITUTE(A2,CHAR(160),"")&" "&B2 When you have this working you could copy the new data and with it still selected use Edit | Paste Special with Multiply checked. Then the new data is free of the old best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Paul" wrote in message ... I have some excel data that I need to merge into one cell... for example ADDR1-ST Num ADDR1-ST Name 111 E MAIN ST I want to put it all in one cell ADDR1-ST Name 111 E MAIN ST I have about 15,000 records so I want the [SPACE] between the Number and the Name any ideas? thanks. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I move this data?
Actually, that was from the email...
111 is in C2, C3, C4....etc E MAIN ST is D2, D3, D4...etc And where do I put this code to do this? in a new column? On Oct 2, 9:33*am, "Bernard Liengme" wrote: If the first address is in A2:B2 then this should work =A2&" "&B2 But your data as some hard-spaces after the 111 (this could have resulted from the email) so you may need to use =SUBSTITUTE(A2,CHAR(160),"")&" "&B2 When you have this working you could copy the new data and with it still selected use Edit | Paste Special with Multiply checked. Then the new data is free of the old best wishes -- Bernard V Liengme Microsoft Excel MVPhttp://people.stfx.ca/bliengme remove caps from email "Paul" wrote in message ... I have some excel data that I need to merge into one cell... for example ADDR1-ST Num * * ADDR1-ST Name 111 * * * * * * * * * * * E MAIN ST I want to put it all in one cell ADDR1-ST Name 111 E MAIN ST I have about 15,000 records so I want the [SPACE] between the Number and the Name any ideas? thanks. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I move this data?
Put the formula in the cell where you want the result; say F14
The copy it down the column to get all the other addresses best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Paul" wrote in message ... Actually, that was from the email... 111 is in C2, C3, C4....etc E MAIN ST is D2, D3, D4...etc And where do I put this code to do this? in a new column? On Oct 2, 9:33 am, "Bernard Liengme" wrote: If the first address is in A2:B2 then this should work =A2&" "&B2 But your data as some hard-spaces after the 111 (this could have resulted from the email) so you may need to use =SUBSTITUTE(A2,CHAR(160),"")&" "&B2 When you have this working you could copy the new data and with it still selected use Edit | Paste Special with Multiply checked. Then the new data is free of the old best wishes -- Bernard V Liengme Microsoft Excel MVPhttp://people.stfx.ca/bliengme remove caps from email "Paul" wrote in message ... I have some excel data that I need to merge into one cell... for example ADDR1-ST Num ADDR1-ST Name 111 E MAIN ST I want to put it all in one cell ADDR1-ST Name 111 E MAIN ST I have about 15,000 records so I want the [SPACE] between the Number and the Name any ideas? thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move data | Excel Worksheet Functions | |||
| Move data? | Setting up and Configuration of Excel | |||
| Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
| enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
| Move Data Table? | Charts and Charting in Excel | |||
Hybrid Mode
