Parsing Data in Excel

  • Thread starter Thread starter aliciabeach
  • Start date Start date
A

aliciabeach

I am trying to parse data within a cell. I have the following tex
within 1 cell
Beach, Alicia/WDC
I am trying to take the WDC and put into a seperate cell withou
retyping. What formula do I use
 
=RIGHT(C5,3

Replace the C5 with the cell you wish to parse and the 3 with the number of char. you want capture in the new cell



----- aliciabeach > wrote: ----

I am trying to parse data within a cell. I have the following tex
within 1 cel
Beach, Alicia/WD
I am trying to take the WDC and put into a seperate cell withou
retyping. What formula do I use
 
If you want to permanently move the WDC, you can use Data>Text to Columns:

Insert a blank column to the right of the column you'll parse
Select the cells that you want to parse
Choose Data>Text to Columns
Select Delimited, click Next
Select Other, and type / in the box, click Next
Click Finish.
 
Back
Top