![]() |
|
#1
|
||||
|
||||
![]()
A quick method would be
Data - Text to columns - Delimited - use space as delimiters - Make sure you set the format to text for the second columns in the next screen - Finish You now have each string in three columns say B C and D n E enter =C1&" "&B1&" "&D1&" " Pull down as needed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move the data at bottom cell to right side of the cell | kcyag91 | Excel | 1 | 01-28-2016 12:28 AM |
![]() |
Gef | Excel | 4 | 02-01-2015 07:14 PM |
How to extract text from a cell and preserve special formatting? | epid011 | Word VBA | 2 | 04-04-2014 04:54 PM |
![]() |
mrayncrental | Word VBA | 8 | 02-06-2014 11:48 PM |
Move data from 1 cell to another cell | Catalin.B | Excel | 1 | 06-25-2011 12:51 PM |