Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Make a Space in a Cell or Delete the Prefix words

Hi Experts,

Im trying to make a space betwen a link

13.10.09\Aldershot-Chelsea-05.08.02-L.jpg

I want to make a space after " \ A" I need to get a space between the backslash and A.

If this is to difficult to do I would like to remove the 13.10.09\ leaving just the Aldershot-Chelsea-05.08.02-L.jpg alone in the cell.

Please let me know.
0
gs1uk
Asked:
gs1uk
  • 3
  • 2
  • 2
  • +1
4 Solutions
 
Eric ZwiekhorstSAP Business ConsultantCommented:
insert column after cells holding the JPG name
Put in the first cell after the first picture name this formula: =MID(cell holding picturename,10,30)

Kind regards

Eric
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
If this is not what you need please upload an example sheet so I can see what you mean...


KR

Eric
0
 
Chris BottomleyCommented:
Select the cells then press ctrl and F then type \ as the find string and \ then space in the replace with and enter

Chris
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Chris BottomleyCommented:
Sorry ctrl & H for replace!

Chris
0
 
MINDSUPERBCommented:
<If this is to difficult to do I would like to remove the 13.10.09\ leaving just the Aldershot-Chelsea-05.08.02-L.jpg alone in the cell.>

Use this formula



=RIGHT(a1,LEN(B5)-FIND("\",a1))

I assume that the value is in A1.

Sincerely,
Ed
0
 
MINDSUPERBCommented:
Sorry,

It must be =RIGHT(A1,LEN(A1)-FIND("\",A1))

Ed
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

alternatively, you can use Text to Columns with the \ sign as the delimiter. That will result in your data being split into two columns:

13.10.09  in the first column and  Aldershot-Chelsea-05.08.02-L.jpg in the second column.

Select the cells with the data, then click Data > Text to Columns > Delimited  > Other and enter a \ sign in the box next to Other > Finish

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The added bonus of the Text to Column method is that the cells contain the actual value and not a formula that just displays the value. With any formula solution, you will probably need to copy the result and use Paste Special - Values to get the actual text of the results into their own cells.
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
Hi Teylyn,

The Text to column is only acceptable if you don't have to do it several time a week, or maybe a day..

If the name of the picture is changing regularly it must be a formula..

Kr

Eric
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now