Parsing Data in Excel

[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

 

[Trevor Shuttleworth]

=Right(A1,3) assuming the data is in Cell A1.

Regards

Trevor

 

[Guest]

=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

 

[Debra Dalgleish]

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.